First Sorted Value

[Anonymous]

Could someone help me alter this FirstSortedValue expression so it returns the 2nd highest value (or the nth highest).

FirstSortedValue(SubSubCategory, -aggr(avg(score),SubSubCategory))

Thanks

[justinphamvn · Accepted solution]

Hi Josh,

Try this : FirstSortedValue(SubSubCategory, -aggr(avg(score),SubSubCategory),2)

Script Syntax : FirstSortedValue - chart function ‒ Qlik Sense

Thank you

Justin