Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sibin_jacob
Not applicable

Max value name Expression

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

1 Solution

Accepted Solutions
jagan
Not applicable

Re: Max value name Expression

Hi,

Use this expression

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

It is working for me.

PFA file for the same.

Regards,

Jagan.

4 Replies
jagan
Not applicable

Re: Max value name Expression

Hi,

Use FirstSortedValue() for this.

=FirstSortedValue(Physician, -Sum(Volume))

Hope this helps you.

Regards,

Jagan.

sibin_jacob
Not applicable

Re: Max value name Expression

HaI Jagan,

I tried this one, but still not working!

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

jagan
Not applicable

Re: Max value name Expression

Hi,

Use this expression

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

It is working for me.

PFA file for the same.

Regards,

Jagan.

sibin_jacob
Not applicable

Re: Max value name Expression

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