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

[kfoudhaily]

you should use the fonction date#(field,'dd/mm/yyyy')

to check for the difference please go to the following link: Date() vs Date#()

[taylor_jesse]

When I use that function in the script, no values show at all in the straight table I did

date#([Contract Renewal Date],'dd/mm/yyyy') as [Contract Renewal Date]

[taylor_jesse]

if(rangesum(before(if([Contract Renewal Date]<=(today()+60),0,ColumnNo()))=0,yellow())

Everything turned yellow

[agomes1971]

Hi,

please share a small sample.

Thanks

André Gomes

[taylor_jesse]

How do I share a sample without sharing the whole document?

[agomes1971]

Hi,

just share a excel with little and scrambled data.

HTH

André Gomes

[taylor_jesse]

Unable to attach any file just images, videos and links.

[agomes1971]

Make reply go to advanced editor!

[taylor_jesse]

Please see the attached file. I will like to make the background color yellow for contract renewal date that are 6 months away but once the date is passed then it should turn back to white.

Thank you

[agomes1971]

Hi,

use this expression:

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

HTH

André Gomes