Incremental Load #fail

[#1]

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;

[MK_QSL]

Try

WHERE Date > $(lastReloadTime);

[Gysbert_Wassenaar]

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;

[sudeepkm]

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

WHERE Date > '$(LastReloadTime)';