Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Try
WHERE Date > $(lastReloadTime);
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;
Please use Gysbert's response. Also you can use like below.
WHERE Date > '$(LastReloadTime)';