QlikSense: Creating QVD file and pointing data

Within an app simply point the script table to the created folder location created ("QVDFiles")

1. Load into QVD

//SQL Connection and query

LIB CONNECT TO [DBConnection];

[vwDimClient]:

LOAD 

[Client],

        [Column2] AS [Measure];

SQL SELECT "Client",

"Column2"

FROM "dbo"."vwTABLE" Where CountryCode = 'US';

//Where going to store and then drop the table created

STORE [vwDimClient] INTO [lib://QVDFiles/Client.qvd](qvd);

DROP Table [vwDimClient];

//Add when want to exit load

EXIT SCRIPT;

2. Point tables to qvd files

You then need to update script to point to qvd instead of table:

//Load from QVD

[vwDimClient]:

LOAD 

[Client],

        [Measure]

FROM [lib://QVDFiles/Client.qvd](qvd);