Solved: Help regarding Advanced aggregation - Qlik Community

Report Inappropriate Content · ‎2013-07-22

Hi folks,

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.

Thanks,

Surendra

swuehl · ‎2013-07-22

Create a chart with dimension Country and two expressions:

=FirstSortedValue(DISTINCT [Sales Person], -Sales)

=max(Sales)

swuehl · ‎2013-07-22

Create a chart with dimension Country and two expressions:

=FirstSortedValue(DISTINCT [Sales Person], -Sales)

=max(Sales)

Report Inappropriate Content · ‎2013-07-22

Thanks a lot swuehl