Store chart data daily

[Bhoomi_walmart]

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?

[Chirantha · Accepted solution]

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

[Bhoomi_walmart]

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.

[deepanshuSh · Accepted solution]

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.