Qlikview Date Color Change setup

[taylor_jesse]

Hi,

I am trying to set a back ground color for a date to turn yellow if its within two months but once the due date is past then I want it to turn white. I used the expression below but it stays yellow even if the date is past due.

For instance already past days are still yellow. I inserted the expression in the background color definition.

if([Contract Renewal Date]<=today()+ 60, Yellow(), White())

Thank you

[taylor_jesse]

Passed dates are still showing Yellow. I will only want current upcoming dates within 6 months to show yellow

[agomes1971]

Please see attached.

Thanks

André Gomes

[taylor_jesse]

Your expression is not picking up the right cells. For instance the second row is suppose to be highlighted red since the date is within 6n months away. When I change your sign to "<=" , no cells are highlighted. The goal is to highlight up coming contract renewal date that is within 6 months away so less than or equal to today plus 6 months.

But once the date is past then the highlight should be off. So future and current dates only should be highlighted

Thank a lot for your help.

[agomes1971 · Accepted solution]

Hi,

hope this it:

=if([Contract Renewal Date] >= Today() and [Contract Renewal Date] <= addmonths(Today(),6), LightRed(), White())

[taylor_jesse]

Thanks for your help

[agomes1971]

Glad to help!

Regards

André Gomes