topic How to change the qvd buffer location in document properties? in QlikView

How to change the qvd buffer location in document properties?

marcobombo — Tue, 14 Feb 2012 09:34:55 GMT

Hi,

I would like to change the location of the qvd buffer location, but I see that it's possible only in the user properties. Can I have this properties for each document and not for each user?

thanks

How to change the qvd buffer location in document properties?

Anonymous — Tue, 14 Feb 2012 11:19:38 GMT

There is no such thing in the Document Properties.
Here is what you can do. Create a variable QVDlocation, assign location to it, and use it in the script. For example:
QVDlocation value is Q:\QVD\
In script:
LOAD
...
FROM $(QVDlocation)MyQVD1.qvd (qvd);

How to change the qvd buffer location in document properties?

Tue, 14 Feb 2012 11:26:27 GMT

Hi,

so far I see your option will be to use the STORE command instead of buffer.

As you detected BUFFER location is only available as User Property.

Example:

STORE MyTable into QVD\MyTable.qvd

So you are able to have different locations for your *.qvd files.

God Luck!

Rainer

How to change the qvd buffer location in document properties?

marcobombo — Tue, 14 Feb 2012 11:41:08 GMT

Thanks a lot, but my goal was to use the buffer (incremental) to avoid having to manage QVD. With buffer (incremental) QlikView handles all that.

How to change the qvd buffer location in document properties?

fernando_tonial — Tue, 14 Feb 2012 12:09:55 GMT

The location of QVDbuffer is not possible to make this change to the document, only by the user.

You can make the creation of explicit QVD, so you can set the recording location through variables.

LET vLocationQVD = 'c:\Data\QVD Extraction\'

Customer:

LOAD *;

SQL Select * from Customer;

Store Customer into $(vLocationQVD)Customer.qvd;

Best Regards.

Tonial