Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

getting error while doing incremental load

Hi Guys,

    I am loading the data from sql server,i have a field callled DOJ and the datatype is date ,that means it displays date

as yyyy-mm-dd,..while i am doing incremental load it gives me an error ..the error is operand type clash date is incompatile

with int.my script for incremental load is

IncLoad:

LOAD id,

    name,

    date(Selectdate) as Selectdate;

SQL SELECT *

FROM NORTHWND.dbo.IncTest where Selectdate>=$(vModDate);

LOAD id,

     name,

     Selectdate

FROM

(qvd) where not exists(id);

could anyone suggest me..

1 Reply
marcus_sommer

Try the variable with single-quotes: Selectdate>='$(vModDate)'

- Marcus