QVD Files

[#1]

Hi Guys

I am trying to create a qvd file .. i am new to this... after writting the store statement I dont see the qvd file where i stored it

Store PhoneReportData into C:\QlikviewReports\WorkingDocuments\QVD\Phones.qvd;

Any explenation?!

Thanks!

[its_anandrjs]

Hi,

Always you have to create a QVD from the code below

Suppose your table name is

PhoneReportData:

Store PhoneReportData into PhoneReportData.qvd;

the QVD is created in the QVW saved location always if you not define the path.

Rgds

Anand

[its_anandrjs]

Hi,

In your example i suggest you have to write

Store PhoneReportData into C:\QlikviewReports\WorkingDocuments\QVD\PhoneReportData.qvd;

QVD name should be the name of the table name.

But all folder location should be correct and true.

Rgds

Anand

[#4]

Thanks!

this is the first time i create a QVD files.

so would u please explain to me how to create it.

Like now I have QVW report and it pulls the information from X, Y tables.

in order to create a qvd file and build the report buy getting data from the QVD what should I do?

Thanks again!

[#5]

Try

STORE * FROM PhoneReportDate into <<write the path here>PhoneReportDate.qvd>

[its_anandrjs]

Hi,

Thanks, Let me explain you. You have to load data like

TableX:

Load

*

From X;

Store TableX into TableX.qvd;   //QVD Creation

TableY:

Load

*

From Y;

Store TableY into TableY.qvd;  //QVD Creation

Drop tables TableX,TableY;

//Loading Data from TableX,TableY QVD

Load

*

From  TableX.qvd;

Load

*

From TableY.qvd;

Rgds

Anand

[#7]

Thanks.

if the table name is NEPTUNE.SDDTA.CUSORD and the second table is NEPTUNE.SDDTA.SALESMAN

that should make it right?

TableCUSORD:

Load

*

From NEPTUNE.SDDTA.CUSORD;

Store NEPTUNE.SDDTA.CUSORD into CUSORD.qvd;

TableSALESMAN:

Load

*

From NEPTUNE.SDDTA.SALESMAN;

Store NEPTUNE.SDDTA.SALESMAN into SALESMAN.qvd;

Drop tables NEPTUNE.SDDTA.CUSORD,NEPTUNE.SDDTA.SALESMAN;

Load

*

From  CUSORD.qvd;

Load

*

From SALESMAN.qvd;

[#8]

I am getting errors in here ..

[#9]

Try this:

load * from SALESMAN.qvd (qvd);

[#10]

I am sorry guys but I think I am doing something wrong..

I created a new report and used the above code to get the information from tables..

is that correct?