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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color Bar Chart by calculated dimension

Hi everyone,

I have a little coloring problem within one of my bar charts.

Capture.PNG

My Dimension definition looks like:

=If(DATEDIFFERENCE >=20,dual('20 or more',20),If(DATEDIFFERENCE < -5,dual('-6 or less',-6),dual(DATEDIFFERENCE,DATEDIFFERENCE)))

And my backgroundcolor definition on my expression states:

If(DATEDIFFERENCE <= 0,Green(),Red())

Unfortunatly "-6 or less" is colored red, although I want it to be colored green. Everything else works just fine. Has anyone an idea, how to accomplish this?

Thanks in advance,

Claus

0 Replies