Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?