Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
b_garside
Partner - Specialist
Partner - Specialist

Please post some sample data or QVW.

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

Not applicable
Author

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

                         thankyou,

TOP2 SALARY.PNG

Digvijay_Singh

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

ramoncova06
Specialist III
Specialist III

here are several expressions that would probably work

Customers Having Top 4 Values

pratap6699
Creator
Creator

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

Not applicable
Author

Thankyou pratap.

Not applicable
Author

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

Not applicable
Author

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

b_garside
Partner - Specialist
Partner - Specialist

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.

Capture.PNG