How to use firstsortedvalue in a dimension

[Anonymous]

Hi all, this is my first post.

Need help trying to limit a dimension. I have created a chart and limit the chart to only show sales people in the top volume region.

I can find my top region by using =FirstSortedValue( region , -aggr( count(ordernumber), region ) )

But i don't know how to limit this to only show sales people in the top region. any help would be appreciated.

[sunny_talwar]

May be this as your calculated dimension

Aggr(If(Count(ordernumber) = Max(TOTAL Aggr(Count(ordernumber), region), region), region)

[qlikviewwizard]

Hi qtran2018 ,

Please check stalwar1 's solution with small correction.

Data:

LOAD * INLINE [

ordernumber,region,sales

1,R1,10

2,R2,20

3,R3,4

4,R4,5

11,R4,20

12,R1,50

14,R2,20

20,R1,20

21,R1,4

22,R2,5

23,R1,20

24,R2,4

25,R3,5

];

[qliksus]

If displaying one region is what you always  want then just create 2 expressions like the below

Exp1 :  FirstSortedValue( region , -aggr(count(ordernumber),region))

Exp2:  sum({<region={$(=FirstSortedValue( region , -aggr(count(ordernumber),region)))}>}sales)

[fabdulazeez]

Count({<region= {"=rank(Count(ordernumber),4)<= 10"}>} ordernumber)

[Anonymous]

Hi Sunny,

I need to display all of the sales people in the top region though. I don't believe this would do it.

[Anonymous]

Hi Susant, sorry i wasnt being clear. i need to show all of the sales people in that region with a count of all of their sales.

[Anonymous]

Hi Fawaz, Sorry I wasn't being clear. i need to display all of the sales people in that top region and a count of all of their sales.

[sunny_talwar]

May be this

Aggr(If(Count(ordernumber) = Max(TOTAL <region> Aggr(Count(ordernumber), region), SalesPerson), region, SalesPerson)

[Anonymous]

Hi Sunny, I tried that to and getting an error in expression