Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prachi91
Creator III
Creator III

QVDPath

hello everyone ,

How to create QVD Path please explain step by step

i tried below script:

SET QVDPath = 'D:\Tech\QVD_PATH';

LOAD [Customer ID],

     [Product ID],

     [Customer Name],

     City,

     [Product Name],

     [Order Date],

     Sales

FROM

$(QVDPath)q1.qvd(qvd);

it shows an error "File Not Found"

then i tried

SET QVDPath = 'D:\Tech\QVD_PATH';

q1:

LOAD [Customer ID],

     [Product ID],

     [Customer Name],

     City,

     [Product Name],

     [Order Date],

     Sales

FROM

[yearly sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE q1 INTO $(QVDPath)q1.qvd(qvd);

its not showing any error but didn't get any qvd file.

help me

Thank You

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Should be this?

STORE q1 INTO $(QVDPath)\q1.qvd(qvd);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

6 Replies
Anil_Babu_Samineni

Should be this?

STORE q1 INTO $(QVDPath)\q1.qvd(qvd);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

stabben23
Master
Master

Hi, you have to add '\' last inQVDPath

SET QVDPath = 'D:\Tech\QVD_PATH\';

prachi91
Creator III
Creator III
Author

thanks its working but is the right way?

SET QVDPath = 'D:\Tech\QVD_PATH';

q1:

LOAD [Customer ID],

     [Product ID],

     [Customer Name],

     City,

     [Product Name],

     [Order Date],

     Sales

FROM

[yearly sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE q1 INTO $(QVDPath)\q1.qvd(qvd);

devarasu07
Master II
Master II

Hi,

Try to do below steps,

keep your excel file under excel folder and QVD files under QVD folder (let say in D drive) and make sure the file exists

SET vQVDPath = '..\QVD';

SET vXLSPath = '..\excel';

LOAD [Customer ID],

     [Product ID],

     [Customer Name],

     City,

     [Product Name],

     [Order Date],

     Sales

FROM $(vQVDPath)\q1.QVD (qvd);

q1:

LOAD [Customer ID],

     [Product ID],

     [Customer Name],

     City,

     [Product Name],

     [Order Date],

     Sales

FROM $(vXLSPath)\yearly sales.xlsx (ooxml, embedded labels, table is Sheet1);

STORE q1 into $(vQVDPath)\q1.QVD (qvd);

Thanks,

Deva

Anil_Babu_Samineni

Yes, Your STORE command should work when you use this?

SET QVDPath = 'D:\Tech\QVD_PATH\';

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prachi91
Creator III
Creator III
Author

Thank you guys for giving your valuable time.