Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ahmar811
Contributor III

Create QVD using Binary load ?


Hi Friend

I have a .qvw file i want  to load data in QlikSense using binary load after that I need to create qvd.

Thank in advance

Ahmar Ansari

Tags (2)
1 Solution

Accepted Solutions
ahmar811
Contributor III

Re: Create QVD using Binary load ?

Thanks for your response friend I got my solution.

6 Replies
MVP
MVP

Re: Create QVD using Binary load ?

Yes you can do this by using a STORE statement after the binary load; but remember that a qvw file can contain many tables, while a qvd contains only a single table, so you may need to create more than one qvd file.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
balrajahlawat
Esteemed Contributor

Re: Create QVD using Binary load ?

You can create but make sure you should know the name of table which is into binary file.

check this as well:

How to create the QVD files in QlikSense ?

How to store table in qliksense

[Qlik Sense] - Store into QVD

MVP & Luminary
MVP & Luminary

Re: Create QVD using Binary load ?

Hi,

Simply write the below statement to create QVD.

STORE QVTableName INTO FileName.qvd;

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Re: Create QVD using Binary load ?

Check this link for sample script.

Storing all tables in Qlikview file to QVD

martinpohl
Valued Contributor II

Re: Create QVD using Binary load ?

Remember:

in Qlik Sense there is the libary-content

Store mytable into xyz.qvd (qvd);

will store the table with desktop into

C:\Users\{user}\Documents\Qlik\Sense\Apps

with server on the server into

C:\Program Data\Qlik\Sense\Apps


While using the libary-content you can define the store-folder

Store mytable into 'lib://FolderConnection/myfile.qvd';

Regards

ahmar811
Contributor III

Re: Create QVD using Binary load ?

Thanks for your response friend I got my solution.