-
Re: Sorting by expression for 2 dimensions in Qlik Sense
Ali Ahmad Nov 28, 2017 3:10 AM (in response to Ann Owe)What did you put under Expression? Could you show a screenshot?
Did you try to just put the dimension name?
-
Re: Sorting by expression for 2 dimensions in Qlik Sense
Ann Owe Nov 28, 2017 3:16 AM (in response to Ali Ahmad )I used "if(aggr(xxx....
I have 2 dimensions on my chart and need to sort one of the dimension from high to low.
-
Re: Sorting by expression for 2 dimensions in Qlik Sense
Ali Ahmad Nov 28, 2017 3:22 AM (in response to Ann Owe)"In bar charts with multiple dimensions, sorting is locked to the first dimension. This dimension is what groups and stacks are based on, and sorting on a different dimension or a measure would break up these groups in an undesirable way. If you still want to sort by the measure value, try using the option Sort by expression on the first dimension under Sorting."
The first dimension Sorting is what decides so tick this one to Sort by Expression and use the expression you want. Should work. See screenshot.
-
-
-
Re: Sorting by expression for 2 dimensions in Qlik Sense
omar bensalem Nov 28, 2017 4:10 AM (in response to Ann Owe)If you want the priority of sorting to be by one dimension (descending in ur case); u have to put above every other thing in the sorting tab