Export a KPI to excel automatically when App is opened or refreshed

[coleturegroup]

My task is to collect specific Qlik Sense KPI's across a range of Apps and save to a file for comparisons in a master Controller App that will read all the files from the saved location. 

I looked at the ExportData method but not sure how to execute that automatically in Qlik Sense either when reload/opening the App or the sheet.

Does anyone have any ideas, examples or direction to proceed?

Thank y'all in advance...

[henrikalmen · Accepted solution]

You could do something like this: perform the calculations you need in load script, and when reloading you export (STORE) the data you want to a qvd (or txt) file. Load the the exported files into the Controller App.

[coleturegroup · Accepted solution]

That is the path I ended up with. It would have been easier to launch a helper object via KPI . 😞

Thanks for the response