topic Re: Simple way to create QVD format in QlikView

Simple way to create QVD format

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Simple way to create QVD format

sunny_talwar — Thu, 14 Jul 2016 23:43:39 GMT

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);

Re: Simple way to create QVD format

rwunderlich — Fri, 15 Jul 2016 00:04:19 GMT

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

Re: Simple way to create QVD format

ramasaisaksoft — Sat, 16 Jul 2016 19:43:03 GMT

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

Re: Simple way to create QVD format

Mon, 18 Jul 2016 14:20:39 GMT

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.