topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Fri, 11 Dec 2009 23:45:54 GMT

I have a stacked bar chart and I want to show the total of all of the stacked bars in text above the bar. Meaning if there are three stacked bars and the first one has a total of 100, the second bar has a total of 50, and the third bar has a total of 50 I want to display 200 in text on top of the the stacked bars.

How do I do this?

Thanks,
Stephen

Stacked Bar Chart

matt_crowther — Sat, 12 Dec 2009 00:03:30 GMT

This may be over simpliyfing the solution but checking the 'Values on Data Points' box under the Expression tab seems to work with my stacked Bar Charts.

Hope that helps,

Matt

Stacked Bar Chart

Sat, 12 Dec 2009 00:25:09 GMT

When I do that only the total for the top bar shows. The bottom two show nothing. But I want to show the total of all three bars.

Stephen

Stacked Bar Chart

matt_crowther — Sat, 12 Dec 2009 00:39:38 GMT

My simple solution seems to only work when you have 2 dimensions and one expression.

So I assume you have more than one expression against your single dimension. In this case what I've tried is as follows:

Assuming our dimension is say 'Year' and our first Expression is say '=sum(Sales)' and our second is '=sum(Bonuses)' I'd leave those 2 expressions with the 'Values on Data Points un-checked and create a 3rd expression; '=sum(Sales)+sum(Bonuses)' set this to be neither a line or a bar but check the 'Values on Data Points' this should now display the total for each stacked bar.

This principal should work no matter how many expressions you're stacking.

Hope that cracks it,

Matt

Stacked Bar Chart

Sat, 12 Dec 2009 01:48:10 GMT

Thanks Matt - that works.

Stephen

Re: Stacked Bar Chart

juraj_misina — Mon, 01 Jul 2013 09:32:23 GMT

Hi,

I just came across this post when trying to achieve the same. I have a stacked bar chart with summary of activities per month, summing up duration of activities within a month. I have two dimensions (MonthYear, Activity) and one expression (sum(duration)). What worked for me was add second expression with TOTAL modifier to leave out Activity dimension, like this:

sum(TOTAL<MonthYear> Duration)

This is not displayed as bar, but only as value on datapoint.

Re: Stacked Bar Chart

Mon, 01 Jul 2013 10:15:44 GMT

Presentation Tab > Text in Chart > ='Total = '&num(sum(Value),'0')

Regards-Bika