Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sindhu_ibizcs
Contributor

convert Qvd file to excel

Hai,

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

Thanks in advance.

1 Solution

Accepted Solutions

Re: convert Qvd file to excel

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

4 Replies

Re: convert Qvd file to excel

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

sureshqv
Esteemed Contributor III

Re: convert Qvd file to excel

Hi,

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

STORE TableName into ;

csv or excl or txt.

vardhancse
Valued Contributor II

Re: convert Qvd file to excel

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

pandunallani
Contributor II

Re: convert Qvd file to excel

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

Community Browser