convert excel files and database tables to qvd

[#1]

Hi, how can I convert excel files and database tables to qvd format without downloading software? Thanks.

[its_anandrjs]

You need at-least the any QV version latest or may be personal edition for this and then,

You have to use STORE command for this see the below load statements

Ex:-

Table1:

Load

Statements

From Excel Location

STORE Table1 into Table1.qvd(qvd);

Table2:

SQL Load

Statements

From from Sql

STORE Table2 into Table2.qvd(qvd);

[shane_spencer]

You will need to download and install QlikView. To do this you can download "personal edition" that does not require a licence. If you upload a file(s) I can build an example script for you.

[avinashelite]

Hi Rachel,

Steps: 1.First import the table to the Qlikview then after the table, please write the below syntax.

//first specify table name

Tablename:

Load*

Select* from

/contact...

               Store Tablename into nameyouwant.qvd(qvd)

Eg :

Mycontacts:

Load*

Select* from

/contact...

Store Mycontacts into Mycontactsdetails.qvd(qvd)

This will automatically save the QVD in the path where your QVW file is stored.

You can specify the path also like Store Mycontacts into //c:Documents/Mycontactsdetails.qvd(qvd)

Regards,

@vi

[#5]

Hi Rachel,

Unfortunataly you will have to download QlikView personal edition to store anything to a .qvd.

Regards,

Marius

[#6]

I can successfully load the tables after typing in the qvd codes but how come all my charts cant display data?

[#7]

Hey thanks, I could successfully load the tables after typing in the qvd codes but how come now all my charts cant display data?

[its_anandrjs]

I believe you drop the tables check your load script for this.

[#9]

so should i drop?

[its_anandrjs]

If you want to use direct load statements as table then do not drop otherwise read the table from the QVD file see the example

Table1:

Load

Statements

From Excel Location

STORE Table1 into Table1.qvd(qvd);

Drop table Table1; // Other wise do not use this line to drop the table

Table1: //From the QVD

Load

*

FROM Table1.qvd(qvd);