Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor

Re: How to display top 2 salary in qlikview with expression?

Please post some sample data or QVW.

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

Not applicable

Re: How to display top 2 salary in qlikview with expression?

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
Honored Contributor III

Re: How to display top 2 salary in qlikview with expression?

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

ramoncova06
Valued Contributor III

Re: How to display top 2 salary in qlikview with expression?

here are several expressions that would probably work

Customers Having Top 4 Values

pratap6699
Contributor

Re: How to display top 2 salary in qlikview with expression?

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

Not applicable

Re: How to display top 2 salary in qlikview with expression?

Thankyou pratap.

Not applicable

Re: How to display top 2 salary in qlikview with expression?

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

Not applicable

Re: How to display top 2 salary in qlikview with expression?

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

b_garside
Valued Contributor

Re: How to display top 2 salary in qlikview with expression?

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

Community Browser