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.
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:
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.
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.
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.