Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to STORE a QVD file

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?

1 Solution

Accepted Solutions
gferran
New Contributor III

Re: How to STORE a QVD file

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

14 Replies
vikasmahajan
Honored Contributor III

Re: How to STORE a QVD file

Try like this

STORE ShipmentFile INTO C:\SFFILE.QVD;

Vikas

umeshathi
New Contributor III

Re: How to STORE a QVD file

Try this one


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

Drive =D

Folder=QVD Files


p_verkooijen
Valued Contributor

Re: How to STORE a QVD file

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)
brijeshma
Contributor

Re: How to STORE a QVD file

Hi,


Try This Way


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

reddys310
Honored Contributor II

Re: How to STORE a QVD file

Hi,

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

oknotsen
Honored Contributor III

Re: How to STORE a QVD file

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!
reddys310
Honored Contributor II

Re: How to STORE a QVD file

Hi Vikas,

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

vikasmahajan
Honored Contributor III

Re: How to STORE a QVD file

ok Thanks  Actually I am not much familiar with sense .

Vikas

p_verkooijen
Valued Contributor

Re: How to STORE a QVD file

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

Community Browser