Sorting Bug in Qlik Sense

[ruanhaese]

Hi everyone

Came across a weird one, not sure if I'm doing something wrong here.

Scenario is simply, I have a dimension (Agents) and an Amount.

If I show (in a table) Agent by Sum(Amount)  then I am able to sort the agents by the highest amount.

If I add another measure (a calculation like RangeSum(Above(...)) ) then the sorting stops working.

In the screenshot the Left Table only sorts by Sales Person name (even though the marker shows sort by Sum(Amount))

the right hand table is what it should look like.

Anyway to get around this so that I can sort with other measures?

[hacr · Accepted solution]

What's your sorting order and settings? Maybe you just need to rearrange the measures under sorting, and add your measure expression as a sorting expression

[ruanhaese]

Thanks, seems like the work around worked.

I added the expression Sum(Amount) on the Dimension - SalesP