topic Re: Store data into Sheets in QlikView

Store data into Sheets

Sun, 28 Jul 2013 11:43:54 GMT

Is it possible to store data from several tables I created into one excel with multiple sheet?

Each table in different sheet?

STORE Report_A into '$(vOutputReport)Report_A.csv'(txt); ---- this in sheet 1

STORE Report_B into '$(vOutputReport)Report_B.csv'(txt); ---- this in sheet 2

So the above “STORE” will be done in the same csv file or excel.

If you know on any external way doing it (not using QV) I will be happy for some guidance.

Cheers.

Re: Store data into Sheets

kaushiknsolanki — Sun, 28 Jul 2013 11:51:07 GMT

Hi,

Have a look at the link below.

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Hope this will help.

Regards,

Kaushik Solanki

Re: Store data into Sheets

Sun, 28 Jul 2013 12:44:12 GMT

Thanks.

This is useful for exporting within QV,

Any idea how the same can be done from the loading script?

Re: Store data into Sheets

kaushiknsolanki — Sun, 28 Jul 2013 12:53:08 GMT

Hi,

As far as i know its not possible with standard functionality of qlikview, but you can write the macros which can help you to achieve the same, but I have not done this before. But sure if I know any I will share the idea or the code with you.

Regards,

Kaushik Solanki