Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
publication1
Contributor III
Contributor III

Get Name of Employee with Maximum Sales

Hi there, looking for a bit of simple Set analysis

I'm using a Multi KPI and inside I just want to show the name of the employee with most Sales.

Table has the columns "NAME" & "SALES"

I can get the Max Number of sales using    =Max(SALES) but unsure how to add this to show the Name of Max Sales

I have tried stuff like ={<MAX(MILES)}>}EIN but no luck

Thanks in Advance and Keep Safe!

 

Labels (1)
1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III

Can you mark my response as a solution?

View solution in original post

3 Replies
JustinDallas
Specialist III
Specialist III

Acting as a sockpuppet for Sunny Talwar with this post,

https://community.qlik.com/t5/New-to-QlikView/how-to-show-highest-sum-sales-and-related-region-in-te...

and using this as dummy data:

DummyData:
LOAD * Inline
[
	'Salesperson','SalesAmount'
    'Ricky',678
    'Ronnie',322
    'Bobby',6000
    'Mike'500
    'Ralph',453
]
;

EXIT Script
;

 

And this as the KPI Measure.

FirstSortedValue(Salesperson, -Aggr(Sum(SalesAmount), Salesperson))

 

I can get the name of the person with the highest sales (Bobby).

 

Is that what you are looking for?

publication1
Contributor III
Contributor III
Author

Exactly what I was after buddy. Thanks so much, actually cant believe how complex it is to do the simple calculations its now saved in my notepad for future reference 

JustinDallas
Specialist III
Specialist III

Can you mark my response as a solution?