Improving Qlikview Export Quality Image

I was at the Ohio Qlik User Group meeting today and saw a very interesting presentation from Mike Czerwonky that I thought should be shared with our readers.

For the longest time, users have been copying static images of charts/graphs from Qlik into PowerPoint, Excel, emails, etc… With the goal of sharing information with other decision-makers who do not have access to the Qlikview application.

This can be easily done by right-clicking on a chart or table and selecting “Copy to Clipboard” > “Image”
Copy to clipboard

However, as you would certainly know if you have ever tried this, the quality of the image is quite poor. During this User Group meeting, the easiest manner of resolving this issue that I have heard to date was presented.

For the sake of comparison, here is a quick look at the results pasted into a word document:

400 Copy in Word

Notice especially in the zoomed area, the pixelation on the names. Overall, the values and grid lines look very fuzzy.

The resolution lies buried in the User Preferences.
Open User Preferences and navigate to the Export Tab.

Clippboard Size

Here, two steps are required.
1) First, ensure that the type of object you want to copy is selected at the top left in the “Include Caption and Border” section. Do not be misled about the caption verbiage, if you have hidden the caption on your object, it will still remain hidden.

This step is important because if your object is not selected, changing the zoom will simply render a smaller area, rather than improving the quality.

2) Second, change the Clippboard Zoom size to something greater than 100. 400 seems to work very well.

For comparison, here is the same image pasted into word once those changes were made:400 Copy in Word

 

One quick warning on this method. Since the changes took place in “User Preferences”, you should be aware that these settings will not be saved in the document if you are placing it on a server or another user opens the file.

, , ,

Comments are closed.