topic Stacked bar chart in QlikView

Stacked bar chart

Mon, 06 Feb 2012 13:15:45 GMT

I wonder if anyone can help me with a stacked bar chart to show overall satisfaction?

The column in my data has the responses: Satisfied, Neither, Dissatisfied.

I just want to show the % of each response in a bar (totalling 100%). This is easy to do as a pie chart but I can't work out how to do it as a bar chart.

Many thanks.

Stacked bar chart

Mon, 06 Feb 2012 13:27:43 GMT

In the property of chart, tab Expression, check Relative

Stacked bar chart

swuehl — Mon, 06 Feb 2012 13:40:25 GMT

So you want a single, total and stacked bar for the responses?

There is something special with a stacked bar chart, you can't use it with just one dimension (e.g. ID) and one expression (e.g. count(Responses) ).

But you can leave out the dimension and use three expressions:

=count({<Response = {Dissatisfied}>} Item) / count(Item)

=count({<Response = {Satisfied}>} Item) / count(Item)

=count({<Response = {Neither}>} Item) / count(Item)

Then use a stacked bar style in style tab and check Show in Percent in Number tab.

Hope this helps,

Stefan

Stacked bar chart

Mon, 06 Feb 2012 14:04:16 GMT

Thanks!!