topic Re: QVD Files in QlikView

QVD Files

Mon, 17 Oct 2011 20:06:28 GMT

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!

QVD Files

its_anandrjs — Mon, 17 Oct 2011 20:09:24 GMT

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

Re: QVD Files

its_anandrjs — Mon, 17 Oct 2011 20:11:51 GMT

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

QVD Files

Mon, 17 Oct 2011 20:19:27 GMT

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!

Re: QVD Files

Mon, 17 Oct 2011 20:23:32 GMT

Try

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

Re: QVD Files

its_anandrjs — Mon, 17 Oct 2011 20:24:35 GMT

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

QVD Files

Mon, 17 Oct 2011 20:35:28 GMT

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;

QVD Files

Mon, 17 Oct 2011 20:39:16 GMT

I am getting errors in here ..

QVD Files

Mon, 17 Oct 2011 20:48:45 GMT

Try this:

load * from SALESMAN.qvd (qvd);

QVD Files

Mon, 17 Oct 2011 20:54:53 GMT

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?

QVD Files

Mon, 17 Oct 2011 20:58:00 GMT

All what i want is to create the QVD files and then i'll go from there

QVD Files

Mon, 17 Oct 2011 21:03:57 GMT

You're aliasing your tables during your load by using labels in you script

TableSALESMAN:
Load
*
From NEPTUNE.SDDTA.SALESMAN;

The table name as far as QlikView is concerned is TableSALESMAN, not NEPTUNE.SDDTA.SALESMAN.

In your example your code should look like this:

TableCUSORD:

Load

From NEPTUNE.SDDTA.CUSORD;

Store TableCUSORD into CUSORD.qvd;

TableSALESMAN:

Load

From NEPTUNE.SDDTA.SALESMAN;

Store TableSALESMAN into SALESMAN.qvd;

Drop tables TableCUSORD, TableSALESMAN;

Load

From CUSORD.qvd;

Load

From SALESMAN.qvd;

Re: QVD Files

its_anandrjs — Tue, 18 Oct 2011 03:59:28 GMT

Hi,

Sorry for response late for your code you have to write

TableCUSORD:

Load

From NEPTUNE.SDDTA.CUSORD;

Store TableCUSORD into TableCUSORD.qvd;

TableSALESMAN:

Load

From NEPTUNE.SDDTA.SALESMAN;

Store TableSALESMAN into TableSALESMAN.qvd;

Drop tables TableCUSORD, TableSALESMAN;

//Loading from QVD

Load

From TableCUSORD.qvd;

Load

From TableSALESMAN.qvd;

From any location or alias you can load the tables but when you give name to table in Qlikview it recognize with that name in this case there is two tables TableCUSORD, TableSALESMAN so load data like this

Rgds

Anand