topic Display sum values above Stacked Bar Chart in QlikView

Display sum values above Stacked Bar Chart

bnichol — Fri, 13 Jan 2012 19:45:26 GMT

Is there a simple way to the display the the sum of a stacked bar above it, similar to checking 'Values on Data Points' for a Bar Chart?

When checking 'Values on Data Points' for a Stacked Bar Chart, the values are displayed for each area, but I only want to see a total for the entire stacked bar.

Any suggestions would be appreciated.

Display sum values above Stacked Bar Chart

m_woolf — Fri, 13 Jan 2012 19:55:40 GMT

Choose Properties.

On the Presentation tab, uncheck Plot Values Inside Segments

Display sum values above Stacked Bar Chart

bnichol — Fri, 13 Jan 2012 20:06:29 GMT

Thanks for the quick response.

Also, great avatar.

Display sum values above Stacked Bar Chart

Anonymous — Wed, 02 May 2012 14:59:33 GMT

Hi,

is it possible to have both at the same time?

"Plot values inside Segments" seems to override "Values on Data Points".

greets Frank

Display sum values above Stacked Bar Chart

Anonymous — Wed, 02 May 2012 15:05:10 GMT

u can do it by keeping the expression and select show values and select invisble ..play around with it ..it should work

Display sum values above Stacked Bar Chart

Anonymous — Wed, 02 May 2012 15:16:56 GMT

Hi Srikanthsri1,

could you perhaps post a little example?

I don't understand what you mean, the bars just disappear.

greets Frank

Display sum values above Stacked Bar Chart

Anonymous — Wed, 02 May 2012 15:23:24 GMT

just have two same exp. in expresssion tab just select invisble for one and select values on data points

Re: Display sum values above Stacked Bar Chart

Anonymous — Wed, 02 May 2012 16:38:14 GMT

Hi,

attached an example, the second expression disabled, because it splits out the stacked bar.

can you take a look please?

I need Values inside the segments as well as totals on top.

greets Frank

EDIT: Typo

Re: Display sum values above Stacked Bar Chart

Anonymous — Wed, 02 May 2012 19:57:20 GMT

sry to say right now i'm working on trail version so , i can't open ur atachment

Re: Display sum values above Stacked Bar Chart

Anonymous — Fri, 15 Feb 2013 16:02:24 GMT

I want the numbers inside the segments and total on top at the same time.

like here: http://4.bp.blogspot.com/_nDnXjC22byg/Sxm9kxo5MYI/AAAAAAAAAbQ/iKZ-RnnUSqg/s1600-h/StackedBarTotal5.JPG

Re: Display sum values above Stacked Bar Chart

m_woolf — Fri, 15 Feb 2013 16:07:31 GMT

This is really messy:

Clone the chart.

Put the values on top of the bars.

Make the new chart invisible and place on top of old chart.

Yuck

Re: Display sum values above Stacked Bar Chart

Anonymous — Fri, 15 Feb 2013 16:10:17 GMT

ok, that means 2 objects, and when exporting, I lose it...

are you aware of any plans to have that in future versions?

Re: Display sum values above Stacked Bar Chart

harleen_singh — Fri, 03 Jan 2014 06:20:35 GMT

hello @Frank billes. I am also looking for its solution did you find it in later versions?

thanks

Lavi

Re: Display sum values above Stacked Bar Chart

Anonymous — Tue, 14 Jan 2014 16:03:58 GMT

no, still not working in one single object.

Re: Display sum values above Stacked Bar Chart

harleen_singh — Thu, 16 Jan 2014 05:30:18 GMT

so somebody asked to Qlikview to avail this feature?

Re: Display sum values above Stacked Bar Chart

Anonymous — Thu, 16 Jan 2014 09:52:51 GMT

how about you file that as an idea ?

Re: Display sum values above Stacked Bar Chart

Thu, 16 Jan 2014 10:32:45 GMT

Hi,

This is possible.

Write 3rd expression as Expression1 + Expression 2 and use Combo chart n make this last expression as Invisible.

Hope this helps.

-Shruti

Re: Display sum values above Stacked Bar Chart

Anonymous — Thu, 16 Jan 2014 11:09:41 GMT

Hi,

technically that works, but you need to add one expression per dimension. --> performance impact if your dataset grows.

Re: Display sum values above Stacked Bar Chart

danielcapp — Wed, 30 Nov 2016 19:51:46 GMT

This did the job to me! Thanks