topic Re: Getting the max value over set analysis in QlikView

Getting the max value over set analysis

Sat, 01 Dec 2012 11:20:37 GMT

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.

Re: Getting the max value over set analysis

swuehl — Sat, 01 Dec 2012 11:45:53 GMT

Maybe like this, using advanced aggregation:

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

Re: Getting the max value over set analysis

Sat, 01 Dec 2012 17:05:17 GMT

Yes, it's work! Thank you!