Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSenseUser2
Contributor III
Contributor III

Background Color expression by date

I'm trying to set a Background Color expression by date. I want it to show green if within a year of the LAST_INSPECTION_DATE  or Red if greater than a year of the LAST_INSPECTION_DATE.

I have 

IF(Year(Aggr(max(LAST_INSPECTION_DATE),TRAILER)) > AddYears(Aggr(max(LAST_INSPECTION_DATE),TRAILER),1), LightRed(),Green())

And I get this all green

 

QlikSenseUser2_0-1626311548631.png

 

0 Replies
Community Browser