Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
My expression returns John based on the highest sale 7000. Whereas I expect Rob to be returned because his sum is 11000. Please help.
may be like this
=FirstSortedValue([Person], Aggr(-Sum([Sales]), Person))
View solution in original post
Have you tried this?
Expression corrected: FirstSortedValue(Person, -Aggr(Sum(Sales),Person))
Try like this
I think so,
= FirstSortedValue(Person, -Aggr(Sum(Sales),Person))
Thanks to both of you. It works!!