topic Re: Export a KPI to excel automatically when App is opened or refreshed in App Development

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

coleturegroup — Thu, 10 Oct 2024 14:23:04 GMT

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

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

henrikalmen — Tue, 19 Nov 2024 11:32:31 GMT

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.

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

coleturegroup — Tue, 19 Nov 2024 13:06:20 GMT

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

Thanks for the response