Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help regarding Advanced aggregation

Hi folks,

I need small help regarding advanced aggregation.

I've data like this.

CountrySales PersonSales
IndiaSurendra2000
IndiaPawan1000
IndiaSuresh5000
USARamesh3000
USAGirish20000
USASurendra1890
USAPawan5349
UKKiran7890
UKSuresh9890
UKRamesh3234
UKGirish5098

All I want to show is the Sales Person who has done the maximum sales across each country.

The result should look like this.

CountrySales PersonSales
IndiaSuresh5000
USAGirish20000
UKSuresh9890

Kindly help me with the expression.

Thanks,

Surendra

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Create a chart with dimension Country and two expressions:

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

=max(Sales)

View solution in original post

2 Replies
swuehl
MVP
MVP

Create a chart with dimension Country and two expressions:

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

=max(Sales)

Not applicable
Author

Thanks a lot swuehl