5 Replies Latest reply: Mar 29, 2011 8:31 AM by Renaud Charlet RSS

    Problem with simple IF Statement

      Hi,

      I am new to QlikView and have written a simple script to extract data from spreadsheets. While doing so, I have placed a simple if statement to compare two date variables and then execute a load if the condition is satisfield. For some reason the control is not executing the load even when the condition is satisfied. I am sure I have made a silly mistake, but not sure what it is. Please can any one help?

      let xyz = Date(FileTime('Data3.xls'));

      let abc = today();

      if xyz = abc then

      CoverDescription:

      Mapping Load

      CoverCode,

      [Short Description]

      FROM

      Data3.xls

      (biff, embedded labels, table is [Coverage-Data$]);

      end if