How to STORE a QVD file

[#1]

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?

[vikasmahajan]

Try like this

STORE ShipmentFile INTO C:\SFFILE.QVD;

Vikas

[Umesh]

Try this one

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

Drive =D

Folder=QVD Files

[p_verkooijen]

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]

Hi,

Try This Way

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

[reddy-s]

Hi,

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

[oknotsen]

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.

[reddy-s]

Hi Vikas,

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

[vikasmahajan]

ok Thanks  Actually I am not much familiar with sense .

Vikas

[p_verkooijen]

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