If condition to check date greater than 3 years

[remo0017]

Hi Everyone,

  I am new to Qliksense and I have a situation to set the colors on Qliksense map object based on Date

Visited_Date

01/29/2015

05/13/2017

01/017/2016

Need to set the colors based on expression the following conditions

If Visited_Date is greater than 3 years set the color to RED, if Visited_Date is less than 3 years set the color to Yellow ?

Could someone help me to write the correct if condition for this issue.

[settu_periasamy · Accepted solution]

May be try like

=if((Today()-VisitedDate )/365>3, Red(), if((Today()-VisitedDate )/365<=3, Yellow(),Green()))

[eduardo_dimperio · Accepted solution]

If((Interval(Today()-Visited_Date,'D')>1095,RED(),Yellow())