Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tizianonear
New Contributor

the student with the max grade

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)

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), ', ')

Community Browser