How to get the name of people in rank one

[diptojyotidutta]

Hi everyone,

I am new to qlik and exploring it currently.

My issue is that i have three fields named Name, Medals and Year. 

If no.of medals does not repeat itself than i am getting the name with the most medals using the syntax:-

Only({<Name = {"=Rank(Sum(Medals))=1"}>} Name)

But if Two or more Names have the most medals as in the case of mine than how shall i get all the names  with most medals. In my screenshot below,  Name D and E have the most medals. So how shall i get the names of both D and E in a text object?

 

[jyothish8807 · Accepted solution]

Hi,

Try this:

=concat(DISTINCT{<Name = {"=Rank(Sum(Medal),1)=1"}>} Name,',',-Medal)

Br,

KC

[diptojyotidutta]

It worked perfectly for me. Thanks for your help @jyothish8807 

[Kashyap_R]

Hi 

Try this 

concat(DISTINCT{<Nam = {"=Num(Aggr(NODISTINCT Rank(TOTAL Sum(Medals), 1, 1),Nam))=1"}>} Nam,',',-Medals)

Thanks

[jyothish8807]

you are welcome, please close the thread by marking the right answer 🙂

Br,

KC

[diptojyotidutta]

Sorry my friend @Kashyap_R  but it didn't worked