topic Re: Incremental Load #fail in QlikView

Incremental Load #fail

Thu, 04 Sep 2014 13:28:39 GMT

Hi,

I'm getting "Error in expression: ')' Expected

Any clue what might be wrong?

regards,

Olle

LET LastReloadTime = ReloadTime();

LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount

FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Incoming);

Incremental_Load1:
CONCATENATE
LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount

FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Incoming)

WHERE (Date > $(lastReloadTime));

Store Incremental_Load1 into 'E:\Ba;

Re: Incremental Load #fail

MK_QSL — Thu, 04 Sep 2014 13:31:09 GMT

Try

WHERE Date > $(lastReloadTime);

Re: Incremental Load #fail

Gysbert_Wassenaar — Thu, 04 Sep 2014 13:31:59 GMT

LastReloadTime is not the same as lastReloadTime. Qlikview is case sensitive:

LET LastReloadTime = ReloadTime();

WHERE (Date > $(lastReloadTime));

Missing closing single quote:

Store Incremental_Load1 into 'E:\Ba;

Re: Incremental Load #fail

sudeepkm — Thu, 04 Sep 2014 13:46:37 GMT

Please use Gysbert's response. Also you can use like below.

WHERE Date > '$(LastReloadTime)';