Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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
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.
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