Issue with > sign

[#1]

Hi All,

I am trying to write a code for Incremental load, however I am facing some error in regards to greater than sign >.

I have attached the print screen of the error, it states  "Filed not Found  - <> >"

The syntax I have used is

LOAD [Row ID],

     [Order ID],

     [Order Date],

     [Ship Date],

     [Ship Mode],

     [Customer ID],

     [Customer Name],

     Segment,

     Country,

     City,

     State,

     [Postal Code],

     Region,

     [Product ID],

     Category,

     [Sub-Category],

     [Product Name],

     Sales,

     Quantity,

     Discount,

     Profit

FROM

(biff, embedded labels, table is Orders$) where [Order Date]>$(MaxDate);

Thanks in Advance

[Anonymous]

How you have declared MaxDate??

[Anonymous]

check this:

Incremental Load in QlikView – Part1 | Learn QlikView

Incremental Load in QlikView – Part2 | Learn QlikView

[tresesco · Accepted solution]

How do you define your variable? Try puttiing single quotes around your $ expansion like:

...where [Order Date]>'$(MaxDate)';

[ahmar811]

Agreed with tresesco‌

[#6]

Thanks guys, your solution worked

[jagan]

Hi,

All date and string values should be in single quotes in where condition like below

(biff, embedded labels, table is Orders$) where [Order Date] > '$(MaxDate)';

Hope this helps you.

Regards,

Jagan.