Discussion Board for collaboration related to QlikView App Development.
I have raw data for prepare invitation list.For Invitation list I need to select agent name who will take care member, so I will select Agent who member have max(sum(sale)).
If you confuse about what I am talking about please see photo as attach file.
Try using FirstSortedValue()
Sale is not field in dimension how should I do?
Then how do you get sales value?
Either use Aggr in formula (see example) or preaggregate data in script with group by.
FirstSortedValue requires 1:1 relationship between sorted field and sort weight field, so you can't use it directly when your sort weight is a result of aggregation.
You can just do something like this
FirstSortedValue(ShopName, -Aggr(Sum(Sales), MemberID))