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?

[igdrazil]

Hi Florence,

I'm using this:

STORE Database INTO database.qvd (qvd);

and it's working just fine. It will save the qvd in your app-directory.

Hope i could help you.

Regards

Chris

[p_verkooijen]

As long as you would like to use dynamic loading and storing you can't stick to standard mode.

For instance the use of QVSource, Google API etc

[gferran · Accepted solution]

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

[#5]

More information: QlikView ‒ Store

[p_verkooijen]

Hi fdebello‌

Please mark the correct and helpfull to help community and other people