Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
nithin2012
Contributor
Contributor

To Show Top Sales Person for each Region

Hi , 

I need to show the top sales person for each region in the dashboard and not using load script. 

Sample Data : - 

nithin2012_0-1593336670933.png

Expected Result : - 

MathewCentral3109
SusanEast3102
JamesWest1284

 

Sales is a measure which calculates the sum . 

Could you please help me to get the required result in the dashboard. 

Labels (2)
1 Solution

Accepted Solutions
Taoufiq_Zarra

Hi,

many possibilities

One solution

Dimension: Rep,Region

Measure:

=if(Rep=FirstSortedValue(total <Region> Rep,-aggr(sum(Sales),Rep,Region)),sum(Sales))

 

output :

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

3 Replies
Taoufiq_Zarra

Hi,

many possibilities

One solution

Dimension: Rep,Region

Measure:

=if(Rep=FirstSortedValue(total <Region> Rep,-aggr(sum(Sales),Rep,Region)),sum(Sales))

 

output :

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
eliran
Creator III
Creator III

Hi,

 

One easy solution is using the following code

max(aggr(sum(Sales),Region,Rep))

 

Eliran.

nithin2012
Contributor
Contributor
Author

HI Eliran , 

I tried this initially but it did not work out for me . I still get all the results 

 

nithin2012_0-1593360012450.png