topic Re: Sum in vertical stacked bar chart in QlikView

Sum in vertical stacked bar chart

Mon, 17 Jun 2013 14:31:40 GMT

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

Anonymous — Mon, 17 Jun 2013 14:39:24 GMT

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

hope it helps

Mon, 17 Jun 2013 14:50:49 GMT

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

Anonymous — Mon, 17 Jun 2013 14:54:38 GMT

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

prodanov — Mon, 17 Jun 2013 14:58:49 GMT

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

Tue, 18 Jun 2013 07:56:28 GMT

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

I don't have the sum

Almost there

Do you have another idea ?

prodanov — Tue, 18 Jun 2013 09:44:11 GMT

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:

Tue, 18 Jun 2013 09:58:50 GMT

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 — Tue, 18 Jun 2013 10:51:24 GMT

Sorry, but I can't do this!

Tue, 18 Jun 2013 11:27:10 GMT

Well maybe anotherone can help

Thanks anyway