topic How can I extract data from a file with extension .qvd on other softwares? in QlikView

How can I extract data from a file with extension .qvd on other softwares?

Thu, 06 Jan 2011 14:53:48 GMT

Is there any way to extract data from files with extension .qvd to use on other softwares without the need to export these data to another type of file?
It should be like an ODBC connecting to the file with extension .qvd and then extracts these data. I´ve already looked in the manual and on this community but I couldn´t find any satisfactory answer. Do we have this option on QlikView 10?

How can I extract data from a file with extension .qvd on other softwares?

stevedark — Thu, 06 Jan 2011 15:43:45 GMT

Hi Savio,

I did see a post some time ago about a piece of software that could read QVD's - but I have never tried it myself.

The short answer is that the QVD is a proprietary file format used for the storage of data specifically for loading into QlikView. As such there is no way to interrogate this except through QlikView.

You can dump a CSV file from a QlikView load script in exactly the same way as you do a QVD - simply put the extension of the file you write to .csv and place '(txt)' at the end of the line. Eg.:

store mytable into myfile.txt (txt);

Hope that helps.

Regards,
Steve

How can I extract data from a file with extension .qvd on other softwares?

suniljain — Fri, 07 Jan 2011 13:59:56 GMT

store mytable into myfile.txt (txt);

this is the one of option.

qvd is proprietary of qliktech so only the tool which is developed by qliktech is able to read.

but for other tool it is not possible

How can I extract data from a file with extension .qvd on other softwares?

Mon, 21 Feb 2011 23:45:11 GMT

Folks,

My question is a little off track but related to file generation.

Can i set up an automated job in qlikview that will generate files of a particular format each day and send it in a mail / place it in a shared dir?

How can I extract data from a file with extension .qvd on other softwares?

rbecher — Tue, 22 Feb 2011 00:17:31 GMT

There is only one tool that can read QVD files: Vizubi

But, the best way is to export into CSV or QVX on version 10.

How can I extract data from a file with extension .qvd on other softwares?

stevedark — Tue, 22 Feb 2011 01:15:17 GMT

Hi there,

To drop a CSV to a file simply load the table as you normally would in the load script and then issue a store statement:

STORE MyTableName INTO .\Data\MyTableName.csv (txt);

That should do the trick.

Regards,
Steve

How can I extract data from a file with extension .qvd on other softwares?

suniljain — Tue, 22 Feb 2011 09:38:24 GMT

Solution Suggested by Steve is Perfect.