Getting the max value over set analysis

[#1]

Hello!

I have following data:

And i want to calculate the highest expression of  A, B, C:

I use expression with set analysis =Concat({<Count={$(=max(Count))}>}Type, '; ') . It works when i select one id but  it doesn't work when no selection.

See attached example.

Help me please.

[swuehl · Accepted solution]

Maybe like this, using advanced aggregation:

=concat(aggr(if(Count= max(total<id> Count),Type),id,Type), '; ')

[#3]

Yes, it's work! Thank you!