topic Re: How to open QVD\QVX files with Excel? in QlikView

How to open QVD\QVX files with Excel?

daniel_f — Mon, 11 Feb 2013 08:09:31 GMT

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

Re: How to open QVD\QVX files with Excel?

hic — Mon, 11 Feb 2013 08:33:46 GMT

You can't.

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

HIC

Re: How to open QVD\QVX files with Excel?

daniel_f — Mon, 11 Feb 2013 08:36:35 GMT

Thanks Henric,

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

how can excel read data from specific tab?

Re: How to open QVD\QVX files with Excel?

hic — Mon, 11 Feb 2013 09:44:24 GMT

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

Re: How to open QVD\QVX files with Excel?

daniel_f — Mon, 11 Feb 2013 09:57:41 GMT

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

Re: How to open QVD\QVX files with Excel?

hic — Mon, 11 Feb 2013 10:00:41 GMT

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

Re: How to open QVD\QVX files with Excel?

daniel_f — Mon, 11 Feb 2013 11:19:56 GMT

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?

Re: How to open QVD\QVX files with Excel?

hic — Mon, 11 Feb 2013 12:05:48 GMT

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

Re: How to open QVD\QVX files with Excel?

daniel_f — Mon, 11 Feb 2013 15:36:57 GMT

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