Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert excel files and database tables to qvd

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

20 Replies
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
Specialist
Specialist

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

Not applicable
Author

Hi Rachel,

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

Regards,

Marius

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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);