How to open QVD\QVX files with Excel?

[daniel_f]

Hi all,

I need to export some data from qlikview model to Excel file, and I want to do it automatically

What I exactly need is to let the Qlikview model do the load data from ERP system, do some manipulation and "prepare" a table to be extracted and opened by excel file.

This excel will load the table (stored by the Qlikview model in QVD\QVX file format) and make other manipulations with macro process.

In this case, I need to prepare a file QVD\QVX to be loaded by excel.

Can someone know how to do that?

Thanks in advance,

Daniel

[hic]

You can't.

But you can store into a tab separated file instead. This Excel can read.

HIC

[daniel_f]

Thanks Henric,

but can you please be more specific with the separated tab?

how can excel read data from specific tab?

[hic]

If you in the script do a "Store <tableName> into <fileName> (txt);" you will get a file that Excel can read straight off.

The same is true if you right-click on a table in the QlikView UI and choose "Export" and the choose the file format "Tab delimited".

HIC

[daniel_f]

The script fails when i trying to store the tacle name under txt format

my script is like that:

"store Data_needed_Temp into ..\QVD\Data_needed(txt);"     or

"store Data_needed_Temp into ..\QVD\Data_needed.txt;"

how it should be?

Daniel

[hic · Accepted solution]

store Data_needed_Temp into "..\QVD\Data_needed.txt" (txt) ;

[daniel_f]

Thanks Henric, i've extracted to TXT and opened by Excel.

by the way, the script doesn't recognuze formats as CSV or XLS right?

[hic]

Oh, yes, you can load both CSV and XLS.

The Store command cannot store into XLS, but it can store to both QVD, CSV and tab separated:

Store <Table> into [FileName.qvd] (qvd);

Store <Table> into [FileName.csv] (txt,delimiter is ',');

Store <Table> into [FileName.txt] (txt,delimiter is '\t');

Note however, that the extension of the file name is irrelevant - it is just a name. Wether it becomes comma delimited or tab delimited depends on the parameter after the file name. The same is true when you load a file: The extension is irrelevant. It is the file specifying parameters that determine what QlikView does.

HIC

[daniel_f]

Thank you Henric, it's working very good !!!