Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sum in vertical stacked bar chart

Hi,

I'd like to add the total value of the related bar in a vertical stacked bar chart. How can i do that ?

The value has to be just above the bar.

Please see the attached expected result.

Thanks

Histo.png-

9 Replies
srikanthsri1
Valued Contributor

Re: Sum in vertical stacked bar chart

write the expression showing the full value and in expression tab enable this to be invisible

hope it helps

Not applicable

Re: Sum in vertical stacked bar chart

A bit, but as I'm a complete beginner i don't know what "write the expression showing the full value" mean

srikanthsri1
Valued Contributor

Re: Sum in vertical stacked bar chart

Okay NO problem ..can you attach a sample file so that i can provide you the solution.

prodanov
Contributor

Re: Sum in vertical stacked bar chart

Copy expression and on tab Expression uncheck "Bar" and "check value on data point".

Not applicable

Re: Sum in vertical stacked bar chart

Thanks but when i do that here's the results !

I don't have the sum

Almost there

Do you have another idea ?

Histo2.png

prodanov
Contributor

Re: Sum in vertical stacked bar chart

Hi,

Sorry for misleading. In my version 11 I delete second expression and on first check Value on data point and Text on axis and report look like this:

eh.png

Not applicable

Re: Sum in vertical stacked bar chart

Indeed, but I need the total bar value on top + the value of each bar segment into the segment not "on axis"

Would you be able to do that in your example ?

Tricky isn't it ?

prodanov
Contributor

Re: Sum in vertical stacked bar chart

Sorry, but I can't do this!

Not applicable

Re: Sum in vertical stacked bar chart

Well maybe anotherone can help

Thanks anyway

Community Browser