topic Re: Max value name Expression in QlikView

Max value name Expression

sibin_jacob — Tue, 05 Mar 2013 16:31:08 GMT

Hai,

I need the physician name having max volume(physician name having the max volume based on time period and geo selection.)

How to get the max value physician name dynamically?

Thanks,

Sibin Jacob.C

jagan — Tue, 05 Mar 2013 16:34:52 GMT

Hi,

Use FirstSortedValue() for this.

=FirstSortedValue(Physician, -Sum(Volume))

Hope this helps you.

Regards,

Jagan.

sibin_jacob — Tue, 05 Mar 2013 17:01:53 GMT

HaI Jagan,

I tried this one, but still not working!

not getting any value... I need the physician name in text object..

jagan — Tue, 05 Mar 2013 17:10:43 GMT

Hi,

Use this expression

=FirstSortedValue(SalesMan, -Aggr(Sum(Sales), SalesMan))

It is working for me.

PFA file for the same.

Regards,

Jagan.

sibin_jacob — Tue, 05 Mar 2013 17:17:11 GMT

Thanks Jagan... It's working fine.....