Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
New Contributor III

Cannot open file

Hi All,

I'm getting error while open loading the from file. My code like below.

Please help me;

SET vSourceData ="E:\BI\QlikViewSamples\NewOSWork\Incremental Model\DataFiles\";

SET vSaveQvd = "E:\BI\QlikViewSamples\NewOSWork\Incremental Model\QVDs\";

LET vQVDCreatedDate = QvdCreateTime("$(vSaveQvd)StudentsList.qvd");

Student:

LOAD Id,

     Name,

     Address,

     M1,

     M2,

     M3,

     M4,

     Total,

     Division,

     Updated

FROM

$(vSourceData)Student.xlsx

//

(ooxml, embedded labels, table is Students);

Store Student into $(vSaveQvd) StudentsList.qvd(qvd);

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Cannot open file

Try it with:

...

FROM

[$(vSourceData)Student.xlsx]

...

- Marcus

Highlighted
Partner
Partner

Re: Cannot open file

can you post a screen shot of the actual error that you get?

Andy

Highlighted
Esteemed Contributor II

Re: Cannot open file

Wrong Quotes in Variable Definition, in Qlikview we use Single Quotes for String

So

SET vSourceData = 'E:\BI\QlikViewSamples\NewOSWork\Incremental Model\DataFiles\';

SET vSaveQvd = 'E:\BI\QlikViewSamples\NewOSWork\Incremental Model\QVDs\';

LET vQVDCreatedDate = QvdCreateTime('$(vSaveQvd)StudentsList.qvd');

Student:

LOAD Id,

     Name,

     Address,

     M1,

     M2,

     M3,

     M4,

     Total,

     Division,

     Updated

FROM

[$(vSourceData)Student.xlsx]

//

(ooxml, embedded labels, table is Students);

Store Student into $(vSaveQvd)StudentsList.qvd(qvd);

Highlighted
Partner
Partner

Re: Cannot open file

Hi Ashok,

can you copy and paste the actual text from the load script, looks like you have retyped it....

Andy

Highlighted
Partner
Partner

Re: Cannot open file

Hi,

Can you send me screen shot of error message while loading the file?

Can you send me your project folder structure?

Muthukumar Pandiyan
Highlighted
Esteemed Contributor II

Re: Cannot open file

ashokpaladugula

please close the thread if your issue is resolved.