Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Madhu,
Try Like this:
rank( sum( salary), 2 )
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.
avinash I wrote that expression like this rank( sum( salary), 2 ) in expression tab. but it display below.it didnot show values.
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
try tis,
If(aggr(Rank(Sum(salary))<=2,salary),salary)