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
Please post some sample data or QVW.
Also what have you tried with expressions so far may help.
this is my straight table I want to display top2 salary in this table with expression pls tell me out brain garside.
thankyou,
Did you try Dimension Limits tab? I think that's the easiest way to handle similar situations.
here are several expressions that would probably work
expre-->sum(if(rank(sum(sales),2)=2)sales)
Thankyou pratap.
pratap it shows error =sum(if(rank(sum(salary),2)=2)salary)
this expression show s error sum(if(rank(sum(salary),2)=2)salary) pls solve this problem.
Madhu,
Place a 2 in the Dimension limits for largest values in this example I have a variable in place of 2 so it can be whatever you wish it to be.
There is no need to create an expression if you using a Straight table.
However if you need it to go in a Text box then you will need one.
The expression you have should work if you go that route.