Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
coleturegroup
Contributor III
Contributor III

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

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

 

Labels (2)
2 Solutions

Accepted Solutions
henrikalmen
Specialist II
Specialist II

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.

View solution in original post

coleturegroup
Contributor III
Contributor III
Author

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

Thanks for the response

View solution in original post

2 Replies
henrikalmen
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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

Thanks for the response