topic Re: QVD in Qlik Learning Discussions

QVD

sakamsureshbabu — Fri, 10 Oct 2014 12:02:04 GMT

HOW QVDS CRATE

DATA IS IN IBEXPERT ( IT IS ONE OF DATA BASE)

DATA IS COLLECTING FORM SERVER

Gysbert_Wassenaar — Fri, 10 Oct 2014 12:04:45 GMT

Your caps lock key seems to be broken. Please buy a new keyboard.

And don't cross post:

Finally, read the help file. Look for the STORE command.

Anonymous — Thu, 16 Oct 2014 11:41:11 GMT

This is an example of how to create a QVD.

Customers:

Load

Company,

CompanyID,

DivisionID,

Country

SQL SELECT *

FROM Customers;

STORE Customers INTO $(vPathName) Customers.qvd;

Drop Table Customers;

Anonymous — Thu, 16 Oct 2014 17:28:22 GMT

If this is what you were looking for please mark as answered.

its_anandrjs — Thu, 16 Oct 2014 18:13:40 GMT

Syntax for QVD creation is with STORE command and syntax is

STORE TableName into TableName.qvd;

Ex1:-

Tab1:

LOAD * Inline

[

COlA

];

STORE Tab1 into Tab1.qvd;

Ex2:-

Let vRawQvdPath = 'C:\YourFolder\Data\App_QVD';

Tab1:

LOAD * Inline

[

COlA

];

STORE Tab1 into $(vRawQvdPath)\Tab1.qvd;