Discussion Board for collaboration related to QlikView App Development.
Hello Qlik Users,
I am trying to create an expression that uses the rank function to return a specific dimension rather than a rank #. Is there a way to do this?
For example, when I am looking at this year as a dimension, I want to have an expression that gives me the best warehouse in terms of sales volume.
So far below is what I have.
This gives me a number, but I am looking to get the Whse_Name. Any Ideas?
Thank you in advance!
May be use FirstSortedValue() function like:
= FirstSortedValue(Whse_Name, -AGGR(Sum(NetSalesUSD),Whse_Name))
View solution in original post