Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ruanhaese
Contributor

Sorting Bug in Qlik Sense

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?

Bug.png

Tags (2)
1 Solution

Accepted Solutions
hacr-sds
Contributor

Re: Sorting Bug in Qlik Sense

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

2018-03-09_09h24_28.png

2 Replies
hacr-sds
Contributor

Re: Sorting Bug in Qlik Sense

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

2018-03-09_09h24_28.png

ruanhaese
Contributor

Re: Sorting Bug in Qlik Sense

Thanks, seems like the work around worked.

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