Hi Experts
Needed help with Stacked bar chart.
I have below table :
ColA Col2 col3 Col4 col5
S p1 INC1 0 1
S p1 INC5 1 0
S p2 INC2 1 0
S p3 INC3 0 0
E p4 INC4 1 1
E p5 INC5 0 1
O p7 INC6 1 1
O p8 INC7 1 0
I am using a bar graph with col1 x-axis and col2 stacked.
Measure as Count(col3).Coloring I am using col4 and col5 condition like
if(count(col4)=0 and count(col5)=0,green(),
if(count(col4)>0 or count(col5)>1,red(),
if(count(col4)=0 and count(col5)=1,yellow)
So a bar graph with colored stacked project is created but my requirement is all greens,yellows and reds should be grouped
current o/p
![Capture1.PNG Capture1.PNG](https://community.qlik.com/t5/image/serverpage/image-id/31985i556AFB00F4F240EE/image-size/large?v=v2&px=999)
desired o/p
![Capture2.PNG](/skins/images/2D6972D47FAF946A5627FA45BDD8D6F1/responsive_peak/images/image_not_found.png)
Can anyone help me to achieve this?