Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new in Qlik Sense, I have this table and I would like to show the student with the max grade in a KPI
Student | Grade
----------------------
Marco | 27
Francesca | 24
Eleonora | 29
Davide | 18
Serena | 21
Federico | 22
I tried something like this but it does not work:
({$<Max([Grade])>}Student)
Try this
FirstSortedValue(Student, -Grade)
Or this
Concat(DISTINCT Aggr(If(Max(TOTAL Grade) = Grade, Student), Student, Grade), ', ')