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/

[stevedark]

Hi Richard,

I'm not sure I follow what your question is.  If you mean can you call the routine externally to QlikView and have it do the export, then the answer is kind of.  If you start QV.exe from a CMD window (or scheduled batch file, etc.) with a /r flag, the document will reload and the macro should fire.

You will need to be careful if you do this from Windows Scheduler though and you have a message box - as there message box will have nowhere to display.

Regards,
Steve

[richardouellett]

Steve

Thank you very much for this information!

Best

Rick

[#4]

Thanks Steve for this code.  You mention in the qvw that it will not fire if called from QV server. Can you expand on that, and do you know of other ways to get it to execute after a reload from server?

[stevedark]

When a document is refreshed from the QMC it does not fire the OnReload macro.  This means the above code would not work in this case.

Options you have are, refreshing that document from Windows Scheduler or using a tool like NPrinting to write out objects to files on a beat.  Let me know if you want more information on either of these options.

Another way I have used recently is to write out HTML from the reload, this works great for text based information and is very low impact.  See this blog post for more information:

http://www.quickintelligence.co.uk/write-csv-qlikview-store/

Steve

[#6]

Hi Steve, sorry for my slow response.  I need some time to sort out what the business is lookking for..

[#7]

I have Excel table and want to download that table into 'Excel with Logo'. Is it possible? I posted same question in different blog. Please help us if possible.

I posted the same in other blog as well..

Is it possible to extract data into “excel template with logo” either from Qlik or Qlik Sense?

[stevedark]

To do this you need to use a tool like NPrinting.  With this you can build a template in Excel and place data and images directly into your Excel template automatically.

There is more information on NPrinting on our website here:

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

Steve

[#9]

Hi,  Great Macro... how do you get the 'screen grab' method to work ?

Tom

[stevedark]

It's not a screen grab, as such, it is exporting the Sheet rather than a specific object.  This gives all objects laid out just as they are on the page.

Hope that helps.

Steve

[#11]

thanks for the quick reply!

So at the moment your demo just exports the graph?

Many thanks!

Tom