QVDs are most commonly created using the
STORE command in the load script. Each QVD is equal to one logical table (named and created in the script), such as in this example:
STORE Sales into C:\QlikView\QVDs\Sales.qvd(qvd);
A variable name can be set up previous to this
STORE statement that defines the QVD storage location. The variable can be created in the following format:
set vSaveQVD = C:\QlikView\QVDs\;
Once created, the variable can be used as in the following
STORE statement. The dollar sign (
$) is called dollar sign expansion in QlikView, and it instructs QlikView to evaluate the
vSaveQVD variable, in this case, to return the location of the saved QVD directory path.
STORE Sales into $(vSaveQVD)Sales.qvd(qvd);
QVDs must always ...