Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
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.
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.