Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

File exists, but not according to qlikview

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?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

1 Reply
maxgro
MVP
MVP

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