Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to save data to excel/pdf while reloading with a batch file...

Hi all,

Please can you assist me:

We would like to generate an excel/pdf sheet on a periodic basis. We would like to run a batch file that reloads QlikView every hour or so. What is the code I need in the module to generate and save the excel/pdf file (not opening it, just saving it)?

My understanding is we need to create a document trigger that will fire the macro on the onPostReload. We reload the document with the batch file and then save an excel/pdf file to disk. Are we on the right track - please help?