Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bnichol
Valued Contributor

Display sum values above Stacked Bar Chart

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.

B

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Display sum values above Stacked Bar Chart

Choose Properties.

On the Presentation tab, uncheck Plot Values Inside Segments

18 Replies
mwoolf
Honored Contributor II

Display sum values above Stacked Bar Chart

Choose Properties.

On the Presentation tab, uncheck Plot Values Inside Segments

bnichol
Valued Contributor

Display sum values above Stacked Bar Chart

Thanks for the quick response.

Also, great avatar.

B

fbl
New Contributor II

Display sum values above Stacked Bar Chart

Hi,

is it possible to have both at the same time?

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

greets Frank

Highlighted
srikanthsri1
Valued Contributor

Display sum values above Stacked Bar Chart

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

fbl
New Contributor II

Display sum values above Stacked Bar Chart

Hi Srikanthsri1,

could you perhaps post a little example?

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

greets Frank

srikanthsri1
Valued Contributor

Display sum values above Stacked Bar Chart

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

fbl
New Contributor II

Re: Display sum values above Stacked Bar Chart

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

srikanthsri1
Valued Contributor

Re: Display sum values above Stacked Bar Chart

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

fbl
New Contributor II

Re: Display sum values above Stacked Bar Chart

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.J...

Community Browser