Discussion Board for collaboration on QlikView Layout & Visualizations.
I need small help regarding advanced aggregation.
I've data like this.
All I want to show is the Sales Person who has done the maximum sales across each country.
The result should look like this.
Kindly help me with the expression.
Go to Solution.
Create a chart with dimension Country and two expressions:
=FirstSortedValue(DISTINCT [Sales Person], -Sales)
Thanks a lot swuehl