topic Re: How to generate qvd files? in QlikView

How to generate qvd files?

Thu, 10 Apr 2014 12:37:44 GMT

hi guys

I want to generate qvd files in qlikview .I do not know how to generate qvd files in qlikview please tell me out.

Regards:

madhu

Re: How to generate qvd files?

its_anandrjs — Thu, 10 Apr 2014 12:39:29 GMT

You have to write

STORE tablename into tablename.qvd;

thats it

Eg:-

Tablename:

load * inline

[

Products

];

Store Tablename into Tablename.qvd;

Store Tablename into D:\QVDLocation\Tablename.qvd;

By any variable also

Let vPath = 'D:\QVDLocation\';

then use for qvd creation

Store Tablename into $(vPath)Tablename.qvd;

Drop table Tablename;

Re: How to generate qvd files?

MK_QSL — Thu, 10 Apr 2014 12:40:13 GMT

TableName:

Load

FieldName1,

FieldName2,

......

From FileName;

Store TableName into 'C:\Data\TableName.qvd' (QVD);

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:40:23 GMT

Ex:

Table:

Load *

From YourSourceFile;

Stoe Table into Yourwish.qvd;

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:41:52 GMT

Hi,

In script:

STORE Table into QVDFile.qvd;

You can also export data from an object in qvd format (right click, export etc)

Hope this helps

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:41:56 GMT

ok anand send to me one example of qvd.how to write that ple tell me

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:43:42 GMT

thank you anand

Re: How to generate qvd files?

ThornOfCrowns — Thu, 10 Apr 2014 12:44:08 GMT

I didn't know that Pierre de Calan, thanks!

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:44:20 GMT

thank you manish

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:44:52 GMT

Thank you Ravi.

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:45:54 GMT

Thank you pierre de calan.

Re: Re: How to generate qvd files?

its_anandrjs — Thu, 10 Apr 2014 12:46:06 GMT

New Update lets see with an example

Eg:- Suppose you have one table i give inline example like ways you can use for any table

Tablename:

load * inline

[

Products

];

Store Tablename into Tablename.qvd;

Drop table Tablename;

Eg2:-

Let vPath = 'D:\';

Let vTablename = 'Products';

$(vTablename):

LOAD Products,

Sales

FROM

(ooxml, embedded labels, table is Sheet1);

Store $(vTablename) into $(vPath)$(vTablename).qvd;

attached is a qvd file

Re: Re: How to generate qvd files?

MK_QSL — Thu, 10 Apr 2014 12:46:22 GMT

Check enclosed file....

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:48:06 GMT

sorry sir I did mistake in your name.thank you james

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:48:28 GMT

thank you calan

Re: Re: How to generate qvd files?

its_anandrjs — Thu, 10 Apr 2014 12:48:58 GMT

Thanks table name is case sensitive and while making qvd you have to use exactly same name to the table name

and from and table box you can store object as QVD while exporting as QVD.

See my attached example

Thanks & Regards

Re: How to generate qvd files?

Thu, 10 Apr 2014 12:51:21 GMT

Hi, a simple example.

Regards.

Re: How to generate qvd files?

Thu, 10 Apr 2014 16:17:16 GMT

your file is not opened in my qlikview personal edition please send to file in another way .Ernesto

Re: How to generate qvd files?

Thu, 10 Apr 2014 16:28:41 GMT

Hi, This is my Example:

Tabla1: // This is the source o table load in qlikview.

LOAD * Inline

[Campo, valor

1,10

2,50

3,30

];

STORE Tabla1 into Tabla1.qvd; // Here, you use Store statement for save data into QVD File

Regards,