Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
pra_kale
Creator III
Creator III

Macro to Export Data in csv

Hi,

I am very new to qlickview. I want a macro which which executes once I reload the application and export table data in a .csv file.

Can any one help me in this.

2 Replies
Colin-Albert

No need for a macro, you can do this directly in the load script.

store TABLENAME into EXPORT_FILENAME.CSV (txt);

pra_kale
Creator III
Creator III
Author

Thank you very much for your reply !!

My actual Requirement is slightly different than what i have mentioned earlier...

I am attaching a sales.qvd in that there are Two sheets namely Main and summary. Main sheets contains a actual data where as summary sheet contains a Pivote tables, currently Three tables are their in the summary sheets, but this tables may increase depending upon the requirement. I want data from Mani sheet should be get exported in the .csv file with any separator like | or , and all the Pivotes tables in the summary sheets should be get exported in the different different excel sheets according to their names in a specified path which i will provide.

It will be great help if you provide solution to this.

Thanks in advance.