Extract data from qvd files

[sakshamagarwal]

Hi All,

I have qvd files and wanted to extract data using REST API/Java code. Is it possible?

Also does qlik support filtering on data at run time from qvd files?

Thanks

[undergrinder]

Hi Saksham,

I don't know if it is possible or not, but I think the easiest way is store the table in csv file as well.

store mytable into xyz.qvd (qvd);

store mytable into myfile.txt (txt);

G.

[sakshamagarwal]

Thanks Gabor for quick response.

But, I want to apply filters on QVD files at runtime and extract that data from Java.

Storing is csv will not fulfill my use case. Also my data is of some hundreds of millions rows.

[rwunderlich]

You can filter the data you load during the script reload.  You can do subsequent filtering at runtime using selections or set analysis.

If you want to let users make selections and then load a subset of QVD data (because it is too big to load all) look at the ODAG solution https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/DataSource/Manage-b...

If you want to use Java to read data directly from QVD files, take a look at the TIQ QVD Java library. https://www.tiq-solutions.de/en/products/qlikview/qvd-converter/

-Rob

[davetrentwipro]

Thanks Rob.

I only saw references to SQL and non-SQL databases in the help and couldn't find any definitive confirmation of QVDs being supported as well until coming to the Partner Portal.

This post that Petter responded to that confirms the same.

However, haven't found an example of how to implement against the QVD.  (Anyone know of any?!)

Is it as simple as dropping in the QVD Load statement instead of the SELECT or are there additional (or different) configurations, wrappers, etc.?

~ Dave