Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Help with Sstacked bar chart

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

 

desired o/p

Capture2.PNG

 

Can anyone help me to achieve this?

 

 

 

Labels (1)
0 Replies