2 Replies Latest reply: May 16, 2016 9:39 AM by Mitchell Boyer RSS

    Using variable in Where statement in load script...

    Mitchell Boyer

      The following error occurred:

      Unknown Error

      The error occurred here:

      LOAD

          [Interview Finish Date]

      FROM [lib://Apps/All Surveys for 16MY CQI Qlik Sense.xlsx]

      Where [Interview Finish Date]<=42501

      (ooxml, embedded labels, table is GridExport)

      Data has not been loaded. Please correct the error and try loading again.

       

      I can't seem to get this to work:

      Where [Interview Finish Date]<=$(MaxIFDate)

       

      It gives me this in the error note:

      Where [Interview Finish Date]<=42501


      For whatever reason, the script is failing and I believe it to be related to the format of the [Interview Finish Date] column, as it is saved in a General format in the xlsx file. Can someone help me figure out the breakdown in syntax/format?

       

      Thanks in advance!