topic Re: Store chart data daily in App Development

Store chart data daily

Bhoomi_walmart — Thu, 06 Jul 2023 13:48:41 GMT

I want to store daily chart details in csv file without download the chart data manual neither with nprinting( not in my company). Is any method to store on daily basis?

Re: Store chart data daily

Chirantha — Thu, 06 Jul 2023 13:52:36 GMT

Hey Bhoomi,

In Qlik Sense, you can use the Store script function to create a CSV file from a table. The Store statement can only export fields from one data table. If fields from several tables are to be exported, an explicit join must be made previously in the script to create the data table that should be exported 1.

Here is an example of how to use the Store function to create a CSV file:

Store [fieldlist from] table into filename [format-spec];

You can find more detailed information on how to use the Store function in the Qlik Help documentation. As for automating this process to run on a daily basis, you could consider using a scheduling tool or script to trigger the reload of your Qlik Sense app at a specific time each day. This would execute the Store statement in your script and create the CSV file

Re: Store chart data daily

Bhoomi_walmart — Fri, 07 Jul 2023 03:39:42 GMT

Hi I want to store table data from frontend chart to csv on daily level without doing manually and without nprinting . save below data as csv.

Re: Store chart data daily

deepanshuSh — Fri, 07 Jul 2023 08:29:04 GMT

Not sure about if possible from the front end directly, but you can design the table containing the required dimensions and measures in the backend and create a store command and store as .csv(txt) when the data gets reloaded daily.