topic Re: Macro to Export Data in csv in QlikView

Macro to Export Data in csv

pra_kale — Sun, 07 Jun 2015 14:06:12 GMT

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.

Re: Macro to Export Data in csv

Colin-Albert — Mon, 08 Jun 2015 15:07:47 GMT

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

store TABLENAME into EXPORT_FILENAME.CSV (txt);

Re: Macro to Export Data in csv

pra_kale — Tue, 09 Jun 2015 05:41:59 GMT

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.