topic Re: Using variable in Where statement in load script... in App Development

Using variable in Where statement in load script...

Anonymous — Fri, 13 May 2016 20:11:08 GMT

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!

Re: Using variable in Where statement in load script...

sunny_talwar — Fri, 13 May 2016 20:50:47 GMT

I think you where clause is not at the right spot, try this by putting it below the (ooxml ....) part:

LOAD [Interview Finish Date]

FROM

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

(ooxml, embedded labels, table is GridExport)

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

Re: Using variable in Where statement in load script...

Anonymous — Mon, 16 May 2016 13:39:51 GMT

I believe that fixed it! Thanks for helping!