How to display top 2 salary in qlikview with expression?

[#1]

HI,

I created straight table  in qlikview.I want to display top2 salary in qlikview with expression.pls tell me out how to display top2 salary in qlikview.

                                                        Thankyou,

Regards

madhu

[avinashelite]

Hi Madhu,

Try Like this:

rank( sum( salary), 2 )

[satishqlik]

Dim-->id,name(If(aggr(Rank(Sum(sal))<=2,name),name)) by edit wth add cal dim

And

Expression--->  Sum(sal)

where as Bottom2 you can add sign

If(aggr(Rank(-Sum(sal))<=2,name),name)

Hope, below snap would be helpful.

[#4]

avinash I wrote that expression like this rank( sum( salary), 2 ) in expression tab. but it display  below.it didnot  show values.

[#5]

IT DISPLAY SECOND HIGHEST ID  BUT I WANT TO DISPLAY 2ND HIGHEST SALARY.PLS SOLVE THIS PROBLEM .HOW TO DISPLAY SECOND HIGHEST SALARY .

REGARDS

MADHU

[buzzy996]

try tis,

If(aggr(Rank(Sum(salary))<=2,salary),salary)