Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
marcobombo
New 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
mov
Esteemed Contributor III

How to change the qvd buffer location in document properties?

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

How to change the qvd buffer location in document properties?

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
New Contributor

How to change the qvd buffer location in document properties?

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
Valued Contributor

How to change the qvd buffer location in document properties?


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

Community Browser