Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!