This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
Try Like this:
rank( sum( salary), 2 )
Dim-->id,name(If(aggr(Rank(Sum(sal))<=2,name),name)) by edit wth add cal dim
where as Bottom2 you can add sign
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 .