Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

Stacked bar: total & sort

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!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

9 Replies
swuehl
MVP
MVP

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
MVP
MVP

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

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

2016-04-03 13_44_33-QlikView x64 - [C__Users_Stefan_Downloads_stack_2.qvw_].png

2016-04-03 13_47_16-QlikView x64 - [C__Users_Stefan_Downloads_stack_2.qvw_].png

dafnis14
Specialist
Specialist
Author

Not yet.... but thanks!

dafnis14
Specialist
Specialist
Author

Hi,

It works!

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

Or, am I doing something wrong?

Thanks!

swuehl
MVP
MVP

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

dafnis14
Specialist
Specialist
Author

Here it is,

Thank you!

swuehl
MVP
MVP

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

dafnis14
Specialist
Specialist
Author

What can I say?

You are gifted

thanks so much!

dafnis14
Specialist
Specialist
Author

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!