Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor

Incremental load implement

Hi I am trying to implement incremental load for one of my dashbaord


issues : DATE' is not a recognized built-in function name/date is not comparable with INT 

i have loaded tables data in qvd and identified date field ,date field i am using it as variable max(datefield) for max date data


when i am trying to concatenate data i am having issues with date and int issues


QVD: name,date,salary     ---date as field for date  max(date) as maxdate

Incremental : 

select name ,date,salary from table employee  where date > maxdate;



load  name,date,salary from qvd;


in this scenario i am getting date issues as maxdate and date field is not compatable  etc...



Labels (1)
1 Reply

Re: Incremental load implement

is the select query running fine?