Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sakshamagarwal
New Contributor

Extract data from qvd files

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

3 Replies
undergrinder
Valued Contributor II

Re: Extract data from qvd files

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
New Contributor

Re: Extract data from qvd files

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.

Re: Extract data from qvd files

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

Community Browser