topic Re: Stacked bar: total & sort in QlikView

Stacked bar: total & sort

dafnis14 — Sun, 03 Apr 2016 11:30:47 GMT

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 — Sun, 03 Apr 2016 11:40:12 GMT

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:

swuehl — Sun, 03 Apr 2016 11:43:46 GMT

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

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

dafnis14 — Sun, 03 Apr 2016 11:59:15 GMT

Not yet.... but thanks!

dafnis14 — Sun, 03 Apr 2016 12:01:52 GMT

Hi,

It works!

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

Or, am I doing something wrong?

Thanks!

swuehl — Sun, 03 Apr 2016 12:17:09 GMT

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

dafnis14 — Sun, 03 Apr 2016 16:14:17 GMT

Here it is,

Thank you!

swuehl — Sun, 03 Apr 2016 16:26:23 GMT

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

dafnis14 — Sun, 03 Apr 2016 16:35:34 GMT

What can I say?

You are gifted

thanks so much!

dafnis14 — Mon, 04 Apr 2016 05:31:09 GMT

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!