Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental Load #fail

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;

3 Replies
MK_QSL
MVP
MVP

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;



talk is cheap, supply exceeds demand
sudeepkm
Specialist III
Specialist III

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

WHERE Date > '$(LastReloadTime)';