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

QVD Creation

Hi All,

How to create QVD files, Different ways to create a QVD

SRS

1 Solution

Accepted Solutions
its_anandrjs

Hi,

Use some thing like this in the script

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

NoConcatenate

load * from

D1;

store Table2 into Table2.qvd;

Regards,

Anand

View solution in original post

29 Replies
christophebrault
Specialist
Specialist

Hi,

After your load statement, you can simply write this code to store a table in a QVD :

STORE YourTable into YourQVDName.QVD;

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

Hi,

Thanks but when i put store statement after the load of the table it works for first table but when creating store statement for the second table it will not creating qvd, is there any other way to create a QVD.

SRS

janardhan
Creator
Creator

Hi Sanjay,

u need to create another tab and place the second table and write the store statement there it will work

for ur convinence or easy to identify tables u need to create new tabs.

Regards

jana

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi Sanjay,

Check out that you are not using the Same qvd Names for store statement of two different tables.

Regards,

Nilesh Gangurde

Not applicable
Author

Hi All,

Thanks to you all my situation is that i load data from the 5 excel files and the excel file contains same fields and there is one sheet its name is also same when i create a qvd of first table it create with its name but not for second.

Can i rename this 5 excel files my motive is that i load this excel files and create QVD of this excel files but the sheet name, fields in the excel is same.

SRS

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi sanjay ,

write your script as follows:

tablename1:

load * from

excel1;

store tablename1 into tablename1.qvd;

tablename2

load *

from excel2;

store tablename2 into tablename2.qvd;

Do it for all the excel and you will get the 5 qvd's

Regards,

Nilesh Gangurde

janardhan
Creator
Creator

Hi Sanjay ,

Nilesh is correct but he missed one thing

tablename1:

load * from

excel1;

store tablename1 into tablename1.qvd;

tablename2:

load *

from excel2;

store tablename2 into tablename2.qvd;

Not applicable
Author

Hi,

My script is like

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

D1 is a sheet name which is from different excel files with same sheet name

but wont work for me.

SRS

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

Add colon at the smily.