O'Reilly logo

QlikView Scripting by Matt Floyd

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating QVDs

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required