emp name with highest salary

[#1]

Hi Experts,

   I am new to qlikview. can anyone help me how to show employee name who is taking highest salary.PFA

[#2 · Accepted solution]

simply use

=FirstSortedValue(empname, -salary)

[#3]

PFA

[#4]

PFA

[#5]

Use:

=FirstSortedValue(empname,-sal)

[ashfaq_haseeb]

Hi Try below

=FirstSortedValue(empname,-sal)

Regards

ASHFAQ

[jsingh71]

FirstSortedValue(empname,-sal)

-- Jai

[#8]

Nice way. i like it. but still i guess there must be a better way.

[IAMDV]

Hi Sruti,

You have 6 answers from 5 different people. Makes me feel that it's more like "Ask the audience" in "Who wants to be a millionaire" than a community question

Anyway, if you wanted to learn how to use FirstSortedValue then you can check the below video blog post.

http://qlikshare.com/?s=firstsortedvalue

Good luck!

Cheers,

DV

[#10]

Hi,

In case there would be several employees with the highest salary you could use:

     =concat(if(sal=max(all sal),empname),', ')

With the data you loaded this results only in 'abc'.

Regards,

Jo