Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting the max value over set analysis

Hello!

I have following data:

table.jpg

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

max.jpg

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like this, using advanced aggregation:

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

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe like this, using advanced aggregation:

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

Not applicable
Author

Yes, it's work! Thank you!