Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register 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
Champion III
Champion III

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
Champion III
Champion III

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

Not applicable
Author

so should i drop?

its_anandrjs
Champion III
Champion III

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