topic Re: Sort Stacked Column Chart by Y-Axis Value?? in QlikView

Sort Stacked Column Chart by Y-Axis Value??

Wed, 16 May 2012 13:59:19 GMT

How do I make it so the Business Unit with the largest quantity is at the bottom of the stacked column and the smallest at the top? Can this be done for each column? Do I have to sort by expression? If so, what would I write?

Sort Stacked Column Chart by Y-Axis Value??

vgutkovsky — Wed, 16 May 2012 16:37:22 GMT

Well, you can't do it for each column independently, but you can sort it by the total quantity per Business Unit (regardless of month). Under sort, select Business Unit Group and then sort it by expression descending, where you expression is sum(quantity) or whatever you used as your actual chart expression.

Regards,

Vlad

Re: Sort Stacked Column Chart by Y-Axis Value??

Tue, 29 Jan 2013 12:12:53 GMT

Thanks Vlad, the above answer is correct! Hunt please mark as correct