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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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