I want to display Top Salary Employee name

[#1]

Hi Community,

     I have same top salary candidates 5 members, how to display all those candidates and how to display only one cadidate.

Regards,

Kalyan.

[sunny_talwar]

Try this may be to display all 5 candidates.

Concat(If(Salary = Max(TOTAL Salary), Candidate), Chr(13))

Not sure which one you would like to display out of those 5 when you want to just display one? Is there any logic there?

[settu_periasamy]

may be use the FirstSortedValue function

[#4]

Hi Sunny,

Using this Concat(If(Salary = Max(TOTAL Salary), Candidate), Chr(13))   display 5 candidates,  but i want to diplay  those all 5 candidates display one candidate only.

[sunny_talwar]

How do you determine which candidate out of those 5 need to be displayed?

[#6]

=FirstSortedValue(Candidate, -Aggr(Max(Salary), Candidate))

[#7]

Hi brijeshqlik ,

Use your exp don't display even top salaries also ,  simply display all candidate names as usual.........

[settu_periasamy]

Can you post the sample qvw?

[sunny_talwar]

If A, B, C, D and E all have max salary (lets say 10k) which one would you want to be displayed?

[tresesco]

PFA