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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion
Partner - Champion

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.