how to get 2nd Highest

[#1]

i want get 2nd highest value in particular column.

which function is used for that?

Please reply.

[rubenmarin]

Maybe with Max(TOTAL YourExpression, 2)

[Gabriel]

Hi,

Probably use Rank() function. I.e

=Rank(YourExpression,4) = 2

[raman_rastogi · Accepted solution]

HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

[#5]

Something Like this

=IF(aggr(Rank(sum(Metric Value)),Your Field)=2,Your Field)

Regards

John