1 Reply Latest reply: Dec 8, 2016 11:33 AM by Massimo Grossi RSS

    File exists, but not according to qlikview

    John Simmons

      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?