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?