Prevent fuzzy images when exporting QlikView graphs

By Barry Harmsen

A short post today on an ‘annoyance’ that invariably pops up at my clients; when copy and pasting images of QlikView objects into their PowerPoint presentation or Word document, the images look blurry and slightly out of focus.

Fortunately, there is an easy way to solve this. Instead of using the regular paste option, use paste special to paste the image as a bitmap.

Difference between regular and special pasting of QlikView objects

In both Office 2007 and 2010, the paste special option can be accessed via the paste drop-down menu on the left of the Home tab/ribbon, or via the Ctrl + Alt + V keyboard shortcut.

That’s it!

About The Author

Barry Harmsen

Hi there, I'm Barry and I'm a Business Intelligence Consultant at Bitmetric and based in the Netherlands. Originally from a background of 'traditional' Data Warehousing, Business Intelligence and Performance Management, for the past 10 years I have been specializing in Qlik and a more user-centric form of BI. I have done numerous QlikView and Qlik Sense implementations in many different roles and industries. In 2012 I co-authored the book QlikView 11 for Developers. You can follow me on Twitter at @meneerharmsen.

15 Comments

  • 1
    February 25, 2012 - 20:50 | Permalink

    This is a really useful tip – thanks for sharing Barry.

  • 2
    Brian
    March 9, 2012 - 05:42 | Permalink

    Any way to do this when pasting an image into an Outlook message via a macro?

    • 3
      March 11, 2012 - 23:11 | Permalink

      Hi Brian,

      That should not be a problem, replace the Paste method with PasteSpecial and set the DataType parameter to wdPasteBitmap, so .PasteSpecial DataType:=wdPasteBitmap.

      Cheers,
      Barry

      • 4
        Brian
        March 13, 2012 - 03:37 | Permalink

        Thanks, I’ll give it a try.

  • 5
    Grant
    April 3, 2012 - 01:05 | Permalink

    Barry,

    Works great for Excel but I had no luck with Powerpoint 2007. I think that’s because Powerpoint 2007 seems to have anti-aliasing turned on by default and I don’t think it can be turned off.

    Grant

  • 6
    Bob
    April 17, 2012 - 23:37 | Permalink

    It’s actually to do with the scaling in Powerpoint. As long as the graphic is at 100% scaling (size and position on the right click on the graphic) it shows as sharp. The paste special bitmap tends to paste at 100% if you are not pasting into a content placeholder.

  • 7
    Brendan
    May 24, 2012 - 15:25 | Permalink

    Hi barry,
    Thanks for the post.
    I am not overly confident with macros and basically adjusted someone elses to work for me.
    In my macro the only area I can see where i define paste method is:
    pasteMode = aryExportDefinition(i,3)
    or
    if (pasteMode = “image”) then
    Call objSource.CopyBitmapToClipboard()

    Is this where i should be changeing my macro to the PasteSpecial DataType?
    If you could help me on this it would be much appreciated as I am struggling on this final part.
    Thanks

  • 8
    June 17, 2012 - 14:53 | Permalink

    When you don’t have an option for Paste Special (as into Outlook as noted above) what I tend to do is post into Paint first and then copy and paste from there. A bit of a pain, but doable. Otherwise I just grab an area of the screen with the excellent Jing from Techsmith.

  • 9
    December 17, 2013 - 16:19 | Permalink

    Any ideas how to solve the resolution problem when dragging a graph on to the dreaded report builder? I have to produce a PDF report for the board and my graph looks smart on screen but when I print the report off the quality is terrible unless I use a flat standard graph template. Any hint of 3D or shading will not render properly. I have a top quality printer on the ‘best quality’ settings and it still looks shoddy!

    Your advice and expertise qould be appreciated!

  • 10
    February 13, 2014 - 13:59 | Permalink

    Hi Justin,

    You’ve probably already found a solution to your conundrum but if not, have a look at this post.

    http://community.qlikview.com/ideas/2710

    Let me know if this works for you.

    Cheers,

    Siz.

  • 11
    Tom Mackay
    August 21, 2014 - 19:30 | Permalink

    Barry,

    I was looking for the PasteSpecial approach macro approach for Powerpoint, your ‘PasteSpecial DataType:=wdPasteBitmap.’ suggestion did not work for me. I did find the below syntax and it works fine, I found option (3) is the best resolution.

    PPSlide.Shapes.PasteSpecial(3) ‘3 seems best 4-11 don’t work

    ‘This is the enum list of Powerpoint paste options

    ‘ppPasteBitmap 1 Paste bitmap.
    ‘ppPasteDefault 0 Paste the default content of the clipboard.
    ‘ppPasteEnhancedMetafile 2 Paste enhanced Metafile
    ‘ppPasteGIF 4 Paste a GIF image.
    ‘ppPasteHTML 8 Paste HTML.
    ‘ppPasteJPG 5 Paste a JPG image.
    ‘ppPasteMetafilePicture 3 Paste a Metafile picture.
    ‘ppPasteOLEObject 10 Paste OLE object.
    ‘ppPastePNG 6 Paste PNG image.
    ‘ppPasteRTF 9 Paste RTF.
    ‘ppPasteShape 11 Paste a shape.
    ‘ppPasteText 7 Paste text.

    I found the above at:
    http://www.mrexcel.com/forum/excel-questions/686767-visual-basic-applications-excel-range-copied-high-resolution-power-point-slide.html

  • 12
    yusuf
    July 12, 2015 - 22:13 | Permalink

    Use the print driver to export graphs to one note and from there you can save your report as word , pdf , web page html file ect

  • 13
    Marcelo
    August 3, 2015 - 19:23 | Permalink

    Hi Barry.

    What about copying/exporting the whole of a dashboard? It does not show in just one screen and I have to scroll down to see it all, but there was a way to export the whole thing that I can’t find anymore…

    Can you help me?

    Regards,
    Marcelo

  • 14
    Widaad
    March 21, 2016 - 13:37 | Permalink

    Hi Barry,

    Is there a way to do this in Macro while exporting it to Qlikview.

    I’m already using vsheet.Range(row,col).Pastespecial but the image is still shabby not as v do it manually in Excel.

    Please help.

    Thanks
    Widaad

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    Read previous post:
    QlikView blog round-up: If-statements, inline tables & EDX

    Time to dust off a posting category that hasn't been getting as much love as it should have; the QlikView...

    Close