Discussion board where members can get started with QlikView.
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?
Go to Solution.
Use this expression
=FirstSortedValue(SalesMan, -Aggr(Sum(Sales), SalesMan))
It is working for me.
PFA file for the same.
Use FirstSortedValue() for this.
Hope this helps you.
I tried this one, but still not working!
not getting any value... I need the physician name in text object..
Thanks Jagan... It's working fine.....