Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
joshpinfoldold
Contributor III
Contributor III

First Sorted Value

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

1 Solution

Accepted Solutions
justinphamvn
Creator II
Creator II

Hi Josh,

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

Script Syntax : FirstSortedValue - chart function ‒ Qlik Sense

Thank you

Justin

View solution in original post

1 Reply
justinphamvn
Creator II
Creator II

Hi Josh,

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

Script Syntax : FirstSortedValue - chart function ‒ Qlik Sense

Thank you

Justin