Stacked bar: total & sort

[dafnis14]

Hi,

I've seen some posts about my issues but none helped me..

In my chart, I cannot achieve a total display for each bar, only by a tool tip.

I would also like to sort the values in each bar - is it possible?

Attached is a simplified example. Please note that my 3rd dimension is originally a group..

Thanks in advance!

[swuehl]

You should be able to show the bar chart totals just using an option on presentation tab, if you are using QV11.20 SR12 or QV12:

Bar Chart Viz Tidbits in Version 12 | Qlikview Cookbook

[swuehl]

With regard to bar chart sorting, use this as third dimension:

=Aggr(Dual(Supplier,Rank(sum(Qty))),Year,Location,Supplier)

[dafnis14]

Not yet.... but thanks!

[dafnis14]

Hi,

It works!

But looks like there is an issue applying it to a group selection...

Or, am I doing something wrong?

Thanks!

[swuehl]

Could you update your simplified sample QVW to include this group?

[dafnis14]

Here it is,

Thank you!

[swuehl · Accepted solution]

I've applied above approach using the advanced aggregation to both your group dimensions.

[dafnis14]

What can I say?

You are gifted

thanks so much!

[dafnis14]

Dear swuehl,

I have noticed that in your example, there are duplicate months (9, for example).

Can you please help me to figure out how to prevent it?

Thanks!