Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple way to create QVD format

First off sorry for the novice question.

I work for a research company that sometimes delivers data back to clients in the format they request.

In this case I have a client who is requesting a qvd format which I just learned is a QlikView format.

We do not use Qlikview in any way so I am investigating if there is a simple way to generate data in a qvd format.

The data would be coming from a relational database like SQL Server but we could convert to csv or any other format that would speed up the process.

I am not opposed to buying software to accomplish this goal but do not want a large server license cost as this is for currently 1 client.

Any help is appreciated.

4 Replies
sunny_talwar

The only way to create a qvd is to first pull the data into a qvw (QlikView file) and then use a STORE statement to put the data into a qvd....

Table:

LOAD Fields...

FROM CSV or datasource;

STORE Table into FileLocation/FileName.qvd (qvd);

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can do what sunny suggested using the free Personal Edition.

If you want to create the QVD from your java, rbecher‌ company licenses a java library to create QVDs.

Another option in RYO is the QVX format, which is an open published standard. QVX should be "good as QVD" for your client.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

ramasaisaksoft

Hi Michael,

1)Buffer load helps to create the QVD files automatically.  The created QVD will be maintained as defined in  User Preferencesà Locations.

Example: Buffer select * from Employees.csv;



2) Sunny  idea

Not applicable
Author

Thank you both for the suggestions.

This has been turned over to our Development department now (which is not in my area) but I have passed on these suggestions as they look forward into Qlik.