Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

Re: convert excel files and database tables to qvd

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
Valued Contributor

Re: convert excel files and database tables to qvd

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.

Re: convert excel files and database tables to qvd

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

Re: convert excel files and database tables to qvd

Hi Rachel,

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

Regards,

Marius

Not applicable

Re: convert excel files and database tables to qvd

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

Not applicable

Re: convert excel files and database tables to qvd

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

Re: convert excel files and database tables to qvd

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

Not applicable

Re: convert excel files and database tables to qvd

so should i drop?

Re: convert excel files and database tables to qvd

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