How to work with Dynamic labels' name in KPI in Qlik Sense

[demo1]

Hello,

I have a question about the label of a KPI that I would like to make dynamic.

I have a team of 20 people (in my database as "player") that make a score every week (in DB: "points of the week"). I would like to create a display of the best score of the week and this score clearly changes every week and consequently also changes the name of the person who records it, which I would like to be displayed on the label.

How can I do this?

Thank you. 

[justISO · Accepted solution]

As you want to add players' age, you just modify the previously described formula to aggregate that too, so:

=FirstSortedValue(Player, -Aggr(Sum(Score), Player,Age))

Another solution would be to list all players with the best score if you aggregate just the score per player:

=concat(distinct aggr(if(sum(Score) = max(total aggr(sum(Score), Player)), Player), Player), ', ')

[demo1]

Thanks! It works whit the first solution

[demo1]

Thank you @GnaneswarReddy  I'll try also with your solution!