topic Re: Stacked Bar Chart Totals Display in QlikView

Stacked Bar Chart Totals Display

Thu, 11 Aug 2011 18:12:07 GMT

Hello, I have probably a very simple question:

I have a stacked bar chart, that shows three different parts that constitute our revenue.

I can display numbers for each individual part, however the requirement is to display the total revenue on top of each bar.

How do I accomplish that?

Here is an example - I can put labels with values on each individual segment, but can't find a way to put numbers for the whole thing.

Re: Stacked Bar Chart Totals Display

johnw — Thu, 11 Aug 2011 18:22:17 GMT

If One, Pending and Run are separate expressions, one way is to add a new expression for the total, as a symbol, set to invisible, with values on data points checkmarked. The symbol won't display, but the value will, giving you the grand total for the segments in the bar, displayed on top of the bar. This doesn't work in version 9 SR4 due to a bug, in case that's the version you're on.

If One, Pending and Run are dimension values, I do not know of any way to get the total to display on top (other than converting them to expressions). Hopefully someone else does (at which point I can update my attached example).

Re: Stacked Bar Chart Totals Display

Thu, 11 Aug 2011 18:36:15 GMT

Thank you, that's exactly what I needed.

Re: Stacked Bar Chart Totals Display

Thu, 04 Apr 2013 01:38:15 GMT

Hi,

what if its a count? i mean instead of the revenue which are stacked what if its a count of items? how will you total it?

Re: Stacked Bar Chart Totals Display

johnw — Thu, 04 Apr 2013 16:28:06 GMT

Nothing in my example indicates that it's revenue. It could be, or it could be a count, or it could be meters, or anything. Why would QlikView care what it's summing up? Perhaps I'm not understanding the question.

Re: Stacked Bar Chart Totals Display

Wed, 14 Jan 2015 09:11:47 GMT

Hi John,

I have a similar problem and followed your suggestion to add an invisible expression. It works, but I have to use a bar chart instead of a combo chart as I'm using two dimensions.

Problem is now, that the gap between each bar and the total value on top is quiet big, Additionally, the scale has a larger max value (150 currently, 80 before I added the invisible expression). So the whole diagram is much smaller and the numbers of the smaller segments disappear.

Is there a way to improve that a bit? I added before / after screenshots to make it more clear, hopefully.

Thanks

Jens

Re: Stacked Bar Chart Totals Display

Wed, 05 Oct 2016 19:25:41 GMT

Hi Jens,

I'm running into the same problem you described. Were you able to find a solution?

Thanks,

Derek

Re: Stacked Bar Chart Totals Display

johnw — Wed, 12 Oct 2016 20:39:57 GMT

I made a chart like this recently. My solution was a complete hack - I put one chart behind the other, one with the stacked bars, one without that dimension, and set the axis max and min manually in both charts to be exactly the same, put one on top of the other, and made the top one transparent, so that the numbers from the bottom chart show at the top of the bars.

But the users found it too busy. I redesigned it with one of my dimensions as a trellis. The bars were then no longer stacked, and only needed to show a single value. It takes a lot more space, of course.

Re: Stacked Bar Chart Totals Display

Shisho_Karsenty — Mon, 25 Sep 2017 13:46:38 GMT

Chart properties --> Presentation --> mark: "Plot values inside segments" + "Still Show Total on Top"