Color Cell in Straight Table if cell date is greater than 6 months from today's date

[#1]

I am trying to get the background expression to change to red if the date that is showing in the straight table is greater than 6 months from todays date.

The expression listed below is what I have been work with no success.

({$<PART_RECEIVED_MMonth={"$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-6),'MMM-YY'))"}>}LightBlue())

Any assistance would be much appreciated

[Anonymous · Accepted solution]

Not sure I completely understand the requirement, but something like this will tell you whether or not the PART_RECEIVED_MMonth field is greater than 6 months from today:

if( date(PART_RECEIVED_MMonth) > date(addmonths(today(), 6)), red())

[settu_periasamy]

Hi,

You can't directly use the Color (LightBlue) in your set expression.

({$<PART_RECEIVED_MMonth={"$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-6),'MMM-YY'))"}>}LightBlue())

May be try something like

If (YourDateField > Date(AddMonths(Today(),6)),Red(),LightBlue())

[Anonymous]

Did you check this?

Set the background color of columns in straight table

Colour on column header (straight table) | Qlik Community

Condition Background Colour On Straight Table D... | Qlik Community