How to find second highest salary

[gkcchowdary]

Hi how find second  highest salary in qlikview

[avinashelite]

Try like this

max(salary,2) // gives as per selection

or

Max({1}salary,2)

[Anonymous]

In your expression, try:

sum({<Salary={'=rank(sum(Salary))=2'}>}Salary)

[Anonymous]

See attached

[#5]

Use the below script in Calculated dimension and use Sum(Salary) in Expression

If(Aggr(Rank(Sum(Salary),Employee)=1,Employee)

Or you can use dimension limits Tab, do the below thing

[trdandamudi]

Look into FirstSortedValue() function....

[muthukumar77]

Use into expression,

If(rank(sum(Salary))=2,sum(Salary),0)

[#8]

You can try:

=FirstSortedValue(Sal, aggr(rank(sum(Sal)),Name), 2)