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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.