topic First Sorted Value in App Development https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/1461369#M36085 <HTML><HEAD></HEAD><BODY><P>Could someone help me alter this FirstSortedValue expression so it returns the 2nd highest value (or the nth highest). </P><P></P><P>FirstSortedValue(SubSubCategory, -aggr(avg(score),SubSubCategory))</P><P></P><P>Thanks</P></BODY></HTML> Tue, 09 Jan 2018 14:01:29 GMT Anonymous 2018-01-09T14:01:29Z First Sorted Value https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/1461369#M36085 <HTML><HEAD></HEAD><BODY><P>Could someone help me alter this FirstSortedValue expression so it returns the 2nd highest value (or the nth highest). </P><P></P><P>FirstSortedValue(SubSubCategory, -aggr(avg(score),SubSubCategory))</P><P></P><P>Thanks</P></BODY></HTML> Tue, 09 Jan 2018 14:01:29 GMT https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/1461369#M36085 Anonymous 2018-01-09T14:01:29Z Re: First Sorted Value https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/1461370#M36086 <HTML><HEAD></HEAD><BODY><P>Hi Josh,</P><P>Try this : <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FirstSortedValue(SubSubCategory, -aggr(avg(score),SubSubCategory),2)</SPAN></P><P>Script Syntax : <A href="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm" title="http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm">FirstSortedValue - chart function ‒ Qlik Sense</A></P><P></P><P>Thank you</P><P>Justin</P></BODY></HTML> Wed, 10 Jan 2018 10:33:42 GMT https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/1461370#M36086 justinphamvn 2018-01-10T10:33:42Z