Reading data from qvd to xls

[#1]

Hi,

Can anyone please let me know if it is possible to read the data from qvd and store the same in xls.If yes, please let me know how this could be done

[tresesco]

You can save file as CSV format and open in excel, like:

temp:
LOAD *
FROM <QVD path> ;

STORE temp into C:\Users\....\Desktop\try.csv (txt);

[its_anandrjs]

You can store the table into xls like below script

Years:

LOAD * Inline

[

Year

2011

2012

2013

2014

];

Store * from Years into Years.xls (txt);

OR

Store * from Years into Years.txt (txt);

OR

Store * from Years into Years.csv (txt);

[#4]

This is possible, You need to use macros for exporting the data in your Qlikview file to an excel sheet. Customize your macro and use it in a Button / Action for saving them to an excel sheet.

[jagan]

Hi,

It is not possible to export to excel from script, instead you can store the data in CSV format and open that file in Excel like this

test:

Load *

FROM QvdFileName.qvd;

STORE test INTO TextFileName.csv;

Hope this helps you.

Regards,
Jagan.