topic Reading data from qvd to xls in QlikView

Reading data from qvd to xls

Mon, 05 May 2014 09:29:50 GMT

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

Re: Reading data from qvd to xls

tresB — Mon, 05 May 2014 09:38:31 GMT

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);

Re: Reading data from qvd to xls

its_anandrjs — Mon, 05 May 2014 09:42:07 GMT

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);

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

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

Re: Reading data from qvd to xls

Mon, 05 May 2014 09:43:35 GMT

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.

Re: Reading data from qvd to xls

jagan — Mon, 05 May 2014 09:48:21 GMT

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.