Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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.