Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display top 2 salary in qlikview with expression?

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

14 Replies
avinashelite

Hi Madhu,

Try Like this:

rank( sum( salary), 2 )

satishqlik
Creator II
Creator II

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.

Not applicable
Author

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

Capture top2 salary.PNG

Not applicable
Author

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
Master II
Master II

try tis,

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