Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

QlikView App: Export Chart and Sheet to an Image File

cancel
Showing results for 
Search instead for 
Did you mean: 
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

QlikView App: Export Chart and Sheet to an Image File

Last Update:

May 29, 2013 5:55:54 PM

Updated By:

stevedark

Created date:

May 29, 2013 5:55:54 PM

Attachments

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/

Comments
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator

Steve

Thank you very much for this information!

Best

Rick

Not applicable

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable

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

Not applicable

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable

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

Tom

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable

thanks for the quick reply!

So at the moment your demo just exports the graph?

Many thanks!

Tom

Version history
Last update:
‎2013-05-29 05:55 PM
Updated by: