Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Store data into Sheets

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.

  1. Cheers.
3 Replies

Re: Store data into Sheets

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

Not applicable

Re: Store data into Sheets

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

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

Community Browser