Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rebelfox
Creator
Creator

Condition Background Colour On Straight Table Date Cell

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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())

View solution in original post

2 Replies
MK_QSL
MVP
MVP

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())

rebelfox
Creator
Creator
Author

Yuop that did it.

Thanks.

So much to learn.....