topic Issue with > sign in QlikView

Issue with > sign

Wed, 16 Dec 2015 08:40:55 GMT

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

Re: Issue with > sign

Anonymous — Wed, 16 Dec 2015 08:43:32 GMT

How you have declared MaxDate??

Re: Issue with > sign

Anonymous — Wed, 16 Dec 2015 08:44:42 GMT

check this:

Incremental Load in QlikView – Part1 | Learn QlikView

Incremental Load in QlikView – Part2 | Learn QlikView

Re: Issue with > sign

tresB — Wed, 16 Dec 2015 08:46:09 GMT

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

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

Re: Issue with > sign

ahmar811 — Wed, 16 Dec 2015 08:57:39 GMT

Agreed with tresesco‌

Re: Issue with > sign

Wed, 16 Dec 2015 08:58:08 GMT

Thanks guys, your solution worked

Re: Issue with > sign

jagan — Wed, 16 Dec 2015 08:58:21 GMT

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.