topic Re: Export table to Excel or .CSV in QlikView

Export table to Excel or .CSV

Wed, 19 Mar 2014 15:55:20 GMT

Hi All,

I am trying to export this huge table (about 100 columns and 37,000 rows) as a .csv file. When I export to Excel, I get a message "Communication lost, closing document" and sometimes it downloads but then is missing about 25 rows. I cannot export as a csv at all. How can I export this table?

I was also wondering if the STORE function is only used for QVDs or can it be used to store the table to a regular Excel or .csv file? I tried it but the file is corrupted and doesn't open. It does create a file though.

Thank you.

Re: Export table to Excel or .CSV

Wed, 19 Mar 2014 17:54:54 GMT

Hi you can store it as csv just like how you would store a qvd. Attached is an example.

Store Table into Table.csv(txt) ;

Re: Export table to Excel or .CSV

Wed, 19 Mar 2014 18:22:15 GMT

Thank you so much for the solution and the example file. I had a syntax error in the Store. Thanks again.