Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

Need expression with firstsortedvalue expression - with all values

Hi there,

I have and expression in chart text -

=FirstSortedValue( distinct [First Ward Start Hour],-Aggr(Sum({<DepartureDate.last_n_days={">=0<=27"}>}[ETP Denominator]-[ETP Numerator]), [First Ward Start Hour]))

I need to show all the five with highest value - marked in red

ashmitp869_0-1657508170447.png

 

Labels (2)
0 Replies