Qlik Community

Qlik Sense App Development

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

joshpinfoldold
New 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

Tags (1)
1 Solution

Accepted Solutions
justinphamvn
Contributor II

Re: First Sorted Value

Hi Josh,

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

Script Syntax : FirstSortedValue - chart function ‒ Qlik Sense

Thank you

Justin

1 Reply
justinphamvn
Contributor II

Re: First Sorted Value

Hi Josh,

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

Script Syntax : FirstSortedValue - chart function ‒ Qlik Sense

Thank you

Justin

Community Browser