topic Qlikview Background Color in QlikView

Qlikview Background Color

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview Background Color

prat1507 — Tue, 05 Jun 2018 13:31:45 GMT

Maybe this

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

Regards

Pratyush

Re: Qlikview Background Color

YoussefBelloum — Tue, 05 Jun 2018 13:33:00 GMT

Hi,

try this:

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

Re: Qlikview Background Color

taylor_jesse — Tue, 05 Jun 2018 15:23:26 GMT

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

Re: Qlikview Background Color

taylor_jesse — Tue, 05 Jun 2018 15:32:47 GMT

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

Re: Qlikview Background Color

YoussefBelloum — Tue, 05 Jun 2018 15:36:27 GMT

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

Re: Qlikview Background Color

taylor_jesse — Tue, 05 Jun 2018 18:37:14 GMT

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