Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: Getting the max value over set analysis

Maybe like this, using advanced aggregation:

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

2 Replies
MVP
MVP

Re: Getting the max value over set analysis

Maybe like this, using advanced aggregation:

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

Not applicable

Re: Getting the max value over set analysis

Yes, it's work! Thank you!

Community Browser