Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

Stack bar sorting issues

Hi, find out sometime we can not sort thing as we want.

Screen Shot 2017-11-02 at 14.17.21.png

here I try to put 'Sum(Sales)' as top sorting criteria but i can not.

Any suggestion How could I sort the stacked bar in term of the total stack sales? (each bar belong to 1 category, could i rank them first from High to Low Sum(Sales))?

Thank you!

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Stack bar sorting issues

If you can't put sum(Sales) above categroy, in category try to sort by expression; an as expression; sum(sales):descending

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Stack bar sorting issues

If you can't put sum(Sales) above categroy, in category try to sort by expression; an as expression; sum(sales):descending

Khan_Mohammed
Honored Contributor II

Re: Stack bar sorting issues

Maybe try below in your sorting?

aggr(Sum(Sales), KATEGORINAMN)

Community Browser