Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marcobombo
Contributor
Contributor

How to change the qvd buffer location in document properties?

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

4 Replies
Anonymous
Not applicable

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);

Not applicable

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

marcobombo
Contributor
Contributor
Author

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.

fernando_tonial
Partner - Specialist
Partner - Specialist


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

Don't Worry, be Qlik.