Hi, I have a stacked bar chart that has one dimension and two measures. the dimension is 'Customer' and the measures are 'SuccessCDR' and 'FailCDR', on the stacked bar chart, I want the 'SuccessCDR' to show as lightgreen() instead of blue and 'FailCDR' to show as lightred() instead of red.
Every example i have found is checking a value like
Except in my case there is no field value, I just want that measure to show up with a different color expression.
Something like this
How do i do this?
You must have a field that contains the 'SuccessCDR' and 'FailCDR' values, so you should be able to use something like :
Simply change the first and second color in the color tab of the chart properties or set the background color of the expressions by clicking on the + sign in front of the expression and use LightGreen() or LightRed() as expression for the background color.
Each Expression have some properties
Go to expression background color of first expression->-> Background color-> Definition-> you can give required color- lightgreen()
2nd expression background color ->Definition -> lightred()
I do have a field that both these measures are based on, its called "CDR_Status"
I put the following :-
expression came out ok, but the barchart remains grey. Any advice?
I am dealing with this colour issue as well...
I just learned that Qlik Sense 2.0 offers no way yet to change stacked bar colour with simple IF statements using multiple measures.
It is possible if you have two dimensions and one measure though. But not with one dimensions and multiple measures. Either with a drill-down dimension.
Please see my reply here:
Re: How to use custom colours in a stacked bar chart
Hope this helps,