Solved: Re: How to STORE a QVD file - Qlik Community

Report Inappropriate Content · ‎2016-01-19

I am using QLIK Sense Desktop. My source data is on an iSeries which I access via an ODBC connection.

I'd like to STORE the data I've retrieved into a QVD file so that I can perform incremental data loads from the source data file.

When I try to STORE my QVD file using this statement

STORE ShipmentFile INTO SFFILE.QVD;

I get an error saying that "No qualified path for file SFFILE.QVD".

I attempted to set a path using "directory" only to run into additional errors stating that "Directory statement only works with lib:\\ paths".

I don't want to store the QVD file on my iSeries, I want to store it on my desktop (for now).

I don't know how to direct where my QVD file is stored, can someone help?

gferran · ‎2016-01-20

Hi,

you must setup a new folder connection and after you can use the next sentence:

STORE TableName into [lib://qvd/]TableName].qvd;

Where qvd is the name of the new folder connection.

Regards,

Gabriel

View solution in original post

vikasmahajan · ‎2016-01-20

Try like this

STORE ShipmentFile INTO C:\SFFILE.QVD;

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Umesh · ‎2016-01-20

Try this one

STORE ShipmentFile INTO D:\QVD Files\ShipmentFile.qvd(qvd);

Drive =D

Folder=QVD Files

p_verkooijen · ‎2016-01-20

You need to disable standard mode to save into directory paths absolute or relative

Qlik Sense Desktop

In order to enable the previous load script behaviour in Qlik Sense Desktop (which is also the standard in QlikView) you will need to follow the instructions from the help to disable the standard mode. The instructions are:

Open C:\Users\{user}\Documents\Qlik\Sense\Settings.ini in a text editor.
Change StandardReload=1 to StandardReload=0.
Save the file and start Qlik Sense Desktop, which will run in legacy mode.
The available settings for StandardReload are:

The available modes are:

1 (standard mode)
0 (legacy mode)

brijeshvma · ‎2016-01-20

Hi,

Try This Way

STORE ShipmentFile INTO [lib://QVDFolder/ShipmentFile.QVD] (qvd);

reddy-s · ‎2016-01-20

Hi,

Try this:STORE ShipmentFile INTO [lib://<Connection Name>/<File name>.qvd];

oknotsen · ‎2016-01-20

That is the way to do it in QlikView. In Qlik Sense you use a library to store your QVDs to.

So I would advise against that suggestion.

May you live in interesting times!

reddy-s · ‎2016-01-20

Hi Vikas,

This syntax would not work in QlikSense untill you enable the legacy mode.

vikasmahajan · ‎2016-01-20

ok Thanks Actually I am not much familiar with sense .

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

p_verkooijen · ‎2016-01-20

There is no enabling Legacy mode setting, disabling the Standard mode will allow you to use legacy scripts.