Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Help regarding Advanced aggregation

Create a chart with dimension Country and two expressions:

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

=max(Sales)

2 Replies
MVP
MVP

Re: Help regarding Advanced aggregation

Create a chart with dimension Country and two expressions:

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

=max(Sales)

Not applicable

Re: Help regarding Advanced aggregation

Thanks a lot swuehl

Community Browser