QlikView App: Export Chart and Sheet to an Image File

[stevedark]

This example shows how to call a macro that saves image files for a selected sheet and chart to a specified location on reload.

The saved images could then be published via a web site or Wall Board, for example.

This QlikView was written in response to a post in the QlikView UK user group.

For other tutorial apps you can download and use, please see:

https://www.quickintelligence.co.uk/qlikview-examples/

Hope you find this app useful.

Steve Dark

http://www.quickintelligence.co.uk/

[#2]

Hello Steve, Actually I am exporting images from report using macro. Its working fine. But I want to export this image when report is publish/schedule on qlikview management console. It means I want to call macro when report is publish/schedule. Can you please advice? Thanks Dipak

[stevedark]

Hi Dipak,

Unfortunately macros will not fire correctly when run from QMC.  Your best bet is to schedule a reload that runs from a batch file (calling qv.exe with a /r parameter) which will cause the batch file to run.  It's a shame that macros don't fire the same from QMC as they do from the command line - but there it is, you just have to work around it.

Steve

[#4]

Hi Steve, Thank you very much for this reply. Dipak

[#5]

Hi All,

Just a quick question in the reverse direction. Is it possible to export a chart from EXCEL to QLIKVIEW?

I suppose this is not a place ask this question yet awaiting answers for the same.

Thanks.,

Sam

[Anonymous]

Import the underlying data and create the graph/chart in QlikView.

If it is just a static chart, never changing, you can of course import it as an image.

Kind regards

Niklas

[#7]

Hi Niklas,

Niklas Hedborg wrote:

Import the underlying data and create the graph/chart in QlikView.

If it is just a static chart, never changing, you can of course import it as an image.

Kind regards

Niklas

Thanks for your input.

But thats the answer I am looking for. How to import a Excel chart as image to Qlikview file?

Thanks

Samuel

[stevedark]

Hi Samuel,

I don't know about the Excel side, but I suspect you could record a macro to save a chart to an image file and then use that to write out the file.

Showing a single image is as simple as adding a Text Object to the sheet and then putting the full path to the file (c:\folder\myimage.png or \\server\folder\myimage.png) in the text box.  You then simply need to change the Representation to Image and set the Image Stretch properties.

If you want a number of images, or to have them in a dynamic location, you can use a list box and/or derive the path to the image in the expression.  Good luck!

Steve

[#9]

Hi Steve,

Thats a very good idea. That really rang a bell.

Let me try that out and let you know the results.

Thanks a lot.

Regards

Samuel

[arbernardez]

Hi!

great idea to create a plain web reporting site

thank you very much!

Alberto Rodríguez

[#11]

Hi, Steve - This is a great example. However, when I opened your sample project and click the button. There is no response. The version I used is QV 11.

By chance, do you know why? Thanks.