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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
QlikSenseUser2
Contributor III
Contributor III
‎2021-07-14 12:35 PM

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

 

299 Views
0 Likes
0 Replies
Community Browser