the student with the max grade

[tizianonear]

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)

[sunny_talwar]

Try this

FirstSortedValue(Student, -Grade)

Or this

Concat(DISTINCT Aggr(If(Max(TOTAL Grade) = Grade, Student), Student, Grade), ', ')