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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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