Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-07-22 11:37 AM

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

365 Views
0 Likes
1 Solution

Accepted Solutions
swuehl
MVP
MVP
‎2013-07-22 11:49 AM

Create a chart with dimension Country and two expressions:

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

=max(Sales)

View solution in original post

260 Views
0 Likes
2 Replies
swuehl
MVP
MVP
‎2013-07-22 11:49 AM

Create a chart with dimension Country and two expressions:

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

=max(Sales)

261 Views
0 Likes
Not applicable
‎2013-07-22 11:54 AM
Author

In response to swuehl

Thanks a lot swuehl

260 Views
0 Likes