Create a particular graphic stacked bar

Andrea_001 — Tue, 03 Mar 2020 18:24:50 GMT

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

Re: Create a particular graphic stacked bar

jochem_zw — Tue, 03 Mar 2020 20:42:00 GMT

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

topic Create a particular graphic stacked bar in App Development

Create a particular graphic stacked bar

Re: Create a particular graphic stacked bar