Qlikview Background Color

[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

[prat1507]

Maybe this

if([Contract Renewal Date]<=AddMonths(today(),-2), Yellow(), White())

Regards

Pratyush

[YoussefBelloum]

Hi,

try this:

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

[taylor_jesse]

I tried this expression and it didn't work out. It did not respond to the expression.

[taylor_jesse]

Hi,

This expression works like my original expression. The background color works even for past dates. I only want it to work for upcoming dates that are 60 days away but once that date is past then the cell is suppose to turn white instead of yellow.

Thank you

[YoussefBelloum]

Is the format of your Date system variable (DateFormat) the same than the format of your field [Contract Renewal Date] ?

[taylor_jesse]

Yes, I used Date#() in the script to change it to date format.