topic Need help with FirstSortedValue in QlikView

Need help with FirstSortedValue

Fri, 30 Aug 2013 05:21:03 GMT

=FirstSortedValue(distinct [Person],-[Sales])

This expression returns the top sales person based on the Highest Sales value, but I want to retrieve the person with the highest Sum(Sales) value.

e.g.

Person Sales

Rob 6000

John 7000

Rob 5000

John 1000

My expression returns John based on the highest sale 7000. Whereas I expect Rob to be returned because his sum is 11000. Please help.

Thanks,

Ram

tresB — Fri, 30 Aug 2013 05:25:25 GMT

Have you tried this?

Edit:

Expression corrected: FirstSortedValue(Person, -Aggr(Sum(Sales),Person))

CELAMBARASAN — Fri, 30 Aug 2013 05:27:01 GMT

may be like this

=FirstSortedValue([Person], Aggr(-Sum([Sales]), Person))

MayilVahanan — Fri, 30 Aug 2013 05:29:35 GMT

Try like this

I think so,

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

Fri, 30 Aug 2013 05:32:35 GMT

Thanks to both of you. It works!!