File exists, but not according to qlikview

Anonymous — Thu, 08 Dec 2016 16:25:47 GMT

Given the following code:

SET vFileName = ..\QVD\Extract\ClinicDashboard\RawWorkload_2014.qvd;
//LET vFileExists = NOT ISNULL(QvdCreateTime([$(vFileName)]));
//LET vFileExists = NOT ISNULL(FileTime([$(vFileName)]));
LET vFileExists = NOT ISNULL(FileSize([$(vFileName)]));

ALL of the three lines that start with "LET vFileExists" returns "0". However, when I do the following, the file loads without an issue:

LOAD * FROM $(vFileName) (qvd);

Why can't I find the file like I'm trying to do?

Re: File exists, but not according to qlikview

maxgro — Thu, 08 Dec 2016 16:33:39 GMT

LET vFileExists = NOT ISNULL(FileSize('$(vFileName)'));

topic Re: File exists, but not according to qlikview in QlikView

File exists, but not according to qlikview

Re: File exists, but not according to qlikview