Create a particular graphic stacked bar

[Andrea_001]

Hi at all,

I'd like to transform two or more graphic pies,  based on a dimension that measures only two % values (YES/NO) (see attached fig1.png),  to one only graphic stacked bar where my dimensions stays on "X - axis"  and the measure that has two different values,  on Y-axis (see attached fig2.png)

Is it possible on QlikSense ?

Can someone help me ?

Thanks

[jochem_zw · Accepted solution]

Yes is possible, you could do it in a bar graph, with 1 dimension and 2 expression, or with 2 dimensions and 1 expression. Suppose we have this table:

Dimension	YesNo	Value	Yes	No
A	Yes	45	45
A	Yes	48	48
A	No	50		50
A	No	49		49
B	Yes	15	15
B	Yes	20	20
B	No	25		25
B	No	30		30

Option 1 would be:

Dimension: Dimension, Expression: Sum(Yes) and Sum(No)

Option 2:

Dimension: Dimension and YesNo, Expression: Sum(Value)

I would prefer Option 2, because in this way you can also make selection on Dimension A or B