https://community.qlik.com/t5/Search-the-Community/Background-Color-expression-by-date/m-p/1822167#M426 <P>I'm trying to set a&nbsp;Background Color expression by date. I want it to show green if within a year of the&nbsp;LAST_INSPECTION_DATE&nbsp; or Red if greater than a year of the&nbsp;LAST_INSPECTION_DATE.</P><P>I have&nbsp;</P><P>IF(Year(Aggr(max(LAST_INSPECTION_DATE),TRAILER)) &gt; AddYears(Aggr(max(LAST_INSPECTION_DATE),TRAILER),1), LightRed(),Green())</P><P>And I get this all green</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QlikSenseUser2_0-1626311548631.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58606i2290D6FB52F5C2A8/image-size/medium?v=v2&amp;px=400" role="button" title="QlikSenseUser2_0-1626311548631.png" alt="QlikSenseUser2_0-1626311548631.png" /></span></P><P>&nbsp;</P> Thu, 15 Jul 2021 01:17:20 GMT QlikSenseUser2 2021-07-15T01:17:20Z https://community.qlik.com/t5/Search-the-Community/Background-Color-expression-by-date/m-p/1822167#M426 <P>I'm trying to set a&nbsp;Background Color expression by date. I want it to show green if within a year of the&nbsp;LAST_INSPECTION_DATE&nbsp; or Red if greater than a year of the&nbsp;LAST_INSPECTION_DATE.</P><P>I have&nbsp;</P><P>IF(Year(Aggr(max(LAST_INSPECTION_DATE),TRAILER)) &gt; AddYears(Aggr(max(LAST_INSPECTION_DATE),TRAILER),1), LightRed(),Green())</P><P>And I get this all green</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QlikSenseUser2_0-1626311548631.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58606i2290D6FB52F5C2A8/image-size/medium?v=v2&amp;px=400" role="button" title="QlikSenseUser2_0-1626311548631.png" alt="QlikSenseUser2_0-1626311548631.png" /></span></P><P>&nbsp;</P> Thu, 15 Jul 2021 01:17:20 GMT https://community.qlik.com/t5/Search-the-Community/Background-Color-expression-by-date/m-p/1822167#M426 QlikSenseUser2 2021-07-15T01:17:20Z