FirstSortedValue Issue

[#1]

Hi Community,

I want to be able to return ID's based on their ranking in the sales field but the issue is when the 2 ID's have the same sales FirstSortedValue returns null instead of the ID. For example FirstSortedValue(Id,Sales,3) and FirstSortedValue(Id,Sales,4) return null. Please advise, thanks!

Keep Qliking!

[JonnyPoole]

Try adding 'distinct' . The expression editor flags it but its saved my bacon a few times

=FirstSortedValue( distinct ID,-Sales,3)

[#3]

Thank you, that works to give me one of the keys for the third ranked value, but I still can't get the second key that also has that same third value.  Any suggestions?

[maxgro]

maybe

=FirstSortedValue( Aggr(Concat(ID,','),Sales),-Aggr(Sales,Sales),3)

from here

Firstsortedvalue