topic Re: convert Qvd file to excel in QlikView

convert Qvd file to excel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hai,

Can anyone explain me ,how to convert Qvd file into excel file.(.csv format).

Thanks in advance.

Re: convert Qvd file to excel

MK_QSL — Wed, 30 Nov 2016 10:45:37 GMT

QVDFILE:
Load * from YourQVDFile;

Store QVDFile into CSVFile.csv(txt);

Read below articles..

https://www.quickintelligence.co.uk/write-csv-qlikview-store/‌

Saving into a CSV file froma script | Qlik Community

Re: convert Qvd file to excel

Chanty4u — Wed, 30 Nov 2016 10:46:07 GMT

Hi,

Load the Qvd into Qlikview and write the stro command as below

STORE TableName into ;

csv or excl or txt.

Re: convert Qvd file to excel

vardhancse — Wed, 30 Nov 2016 10:49:27 GMT

Hi Using store we can :

Store mytable into xyz.qvd (qvd);

Store * from mytable into xyz.qvd;

Store Name, RegNo from mytable into xyz.qvd;

Store Name as a, RegNo as b from mytable into xyz.qvd;

store mytable into myfile.txt (txt);

store * from mytable into myfile.txt (txt);

Re: convert Qvd file to excel

Anonymous — Thu, 01 Dec 2016 04:23:30 GMT

Hi Sindhu,

You can do same as like QVD creation.

Store Table Name into C:\....\.....\Desktop\sales.csv ;//path location where you want to save otherwise if you give only filename it will save at QVW location.

--> For text file

Store qvd into demo.txt(txt);

Regards

Pavan