Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

the student with the max grade


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:


1 Reply

Re: the student with the max grade

Try this

FirstSortedValue(Student, -Grade)

Or this

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