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

[b_garside]

Please post some sample data or QVW.

Also what have you tried with expressions so far may help.

[#3]

this is my straight table I want to display top2 salary in this table with expression pls tell me out brain garside.

                         thankyou,

[Digvijay_Singh]

Did you try Dimension Limits tab? I think that's the easiest way to handle similar situations.

[ramoncova06]

here are several expressions that would probably work

Customers Having Top 4 Values

[pratap6699]

expre-->sum(if(rank(sum(sales),2)=2)sales)

[#7]

Thankyou pratap.

[#8]

pratap it shows error =sum(if(rank(sum(salary),2)=2)salary)

[#9]

  this expression show s  error sum(if(rank(sum(salary),2)=2)salary) pls solve this problem.

[b_garside]

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.