topic Value of highest count in QlikView

Value of highest count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to get the value which belongs to the highest count. So:

Name: Count:

Paul 1

David 1

Harry 1

David 1

So, now I want an expression which gives David as a output as he has the highest count.

Thank you!

sergio0592 — Sun, 12 Nov 2017 17:26:39 GMT

Hi, try with :

=FirstSortedValue(Name,-aggr(sum(Count),Name))

Anonymous — Sun, 12 Nov 2017 18:26:59 GMT

That worked, thanks!

Monicalingan — Sun, 12 Nov 2017 23:31:50 GMT

Hi Joost,

Few more ways

=if(Right(Text(Name&'/'&Rank(Count(Name))),2)='/1',Name,'')

=if(Right(Text(Name&'/'&Rank(Sum(Count))),2)='/1',Name,'')