https://community.qlik.com/t5/QlikView/Need-expression-with-firstsortedvalue-expression-with-all-values/m-p/1953777#M1219840 <P>Hi there,</P> <P>I have and expression in chart text -</P> <P>=FirstSortedValue( distinct [First Ward Start Hour],-Aggr(Sum({&lt;DepartureDate.last_n_days={"&gt;=0&lt;=27"}&gt;}[ETP Denominator]-[ETP Numerator]), [First Ward Start Hour]))</P> <P>I need to show all the five with highest value - marked in red</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ashmitp869_0-1657508170447.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83747i1239399A083C1B67/image-size/medium?v=v2&amp;px=400" role="button" title="ashmitp869_0-1657508170447.png" alt="ashmitp869_0-1657508170447.png" /></span></P> <P>&nbsp;</P> Mon, 11 Jul 2022 02:57:15 GMT ashmitp869 2022-07-11T02:57:15Z https://community.qlik.com/t5/QlikView/Need-expression-with-firstsortedvalue-expression-with-all-values/m-p/1953777#M1219840 <P>Hi there,</P> <P>I have and expression in chart text -</P> <P>=FirstSortedValue( distinct [First Ward Start Hour],-Aggr(Sum({&lt;DepartureDate.last_n_days={"&gt;=0&lt;=27"}&gt;}[ETP Denominator]-[ETP Numerator]), [First Ward Start Hour]))</P> <P>I need to show all the five with highest value - marked in red</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ashmitp869_0-1657508170447.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83747i1239399A083C1B67/image-size/medium?v=v2&amp;px=400" role="button" title="ashmitp869_0-1657508170447.png" alt="ashmitp869_0-1657508170447.png" /></span></P> <P>&nbsp;</P> Mon, 11 Jul 2022 02:57:15 GMT https://community.qlik.com/t5/QlikView/Need-expression-with-firstsortedvalue-expression-with-all-values/m-p/1953777#M1219840 ashmitp869 2022-07-11T02:57:15Z