topic Condition Background Colour On Straight Table Date Cell in QlikView

Condition Background Colour On Straight Table Date Cell

rebelfox — Tue, 07 Jul 2015 15:13:14 GMT

I have a contract table which includes the fields:-

[Contract Start Date]
[Contract Duration In Months]
[Contract Status]

I want to list the columns in a straight table and then add one more column
showing the date the contract should expire.
This is calculated as:- addmonths (Contract_Start_Date, Contract_Duration_in_Months)
as Contract_Expire_Date on the table load.

However…I would like the straight table to highlight the Contract_Expire_Date background
in red if the Contract_Expire_Date has passed current date ( i.e. Contract_Expire_Date < Today() ).

However I’m not sure how to do that.
There is the ‘Visual Cues’ tab with an ‘Upper’ and ‘Lower’ option but I’m not
clear how to code this as an expression that would work. Is there another way?

Guidance would be appreciated.

Re: Condition Background Colour On Straight Table Date Cell

MK_QSL — Tue, 07 Jul 2015 15:19:32 GMT

Click on + sign on your Contract_Expire_Date or any other expression you have used.

Write below in Background color expression

IF(AddMonths([Contract Start Date],[Contract Duration In Months]) <= Today(), RED())

Re: Condition Background Colour On Straight Table Date Cell

rebelfox — Tue, 07 Jul 2015 15:41:22 GMT

Yuop that did it.

Thanks.

So much to learn.....