Discussion board where members can get started with Qlik Sense.
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?
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
View solution in original post
Thanks, seems like the work around worked.
I added the expression Sum(Amount) on the Dimension - SalesP