Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change bar color for last day of every month

Hi, how can I change the color of a bar if it is the last available day of every month?? See picture for reference. Thanks in advance!Capture.PNG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe add a background color attribute expression (expression tab -> open attributes by clicking on small plus sign next to the expressions) like

=If( Month(DateDimField) <> Below( Month(DateDimField)), Yellow() , LightBlue() )

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe add a background color attribute expression (expression tab -> open attributes by clicking on small plus sign next to the expressions) like

=If( Month(DateDimField) <> Below( Month(DateDimField)), Yellow() , LightBlue() )

Anonymous
Not applicable
Author

Thank you Stefan, worked like a charm!