9 Replies Latest reply: Jun 14, 2015 6:59 AM by Abhishek Pansotra

# HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

HI,

I WROTE EXPRESSION LIKE THIS RANK(SUM(SALARY),2) IN EXPRESSION TAB . BUT IT DISPLAYED 2ND

IT DISPLAY SECOND HIGHEST ID  BUT I WANT TO DISPLAY 2ND HIGHEST SALARY.PLS SOLVE THIS PROBLEM .HOW TO DISPLAY SECOND HIGHEST SALARY .

REGARDS

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

Sum(Max(Salary,2))

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

HI RAKESH KUMAR,I WROTE EXPRESSION LIKE THIS SUM(MAX(SALARY,2))BUT IT DISPLAY MAX SALARY ID NUIMBER IT DOES NOT DISPALY 2ND HIGHEST SALARY.I WANT TO DISPLAY 2ND HIGHEST SALARY PLS

TELL ME OUT HOW TO DISPLAY 2ND SALARY IN QLIKVIEW.

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

Sorry I didn't understood your question?

If you just want the second highest salary , you can create a text box with this expression: Max(Salary,2)

I dont understand what you are trying to show inside the Straight table? Can you post a example output on what you are expecting, ex. fill an excel table , take a screenshot and post it so I can understand?

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

HELLO RAKESH KUMAR.I WANT TO DISPALY 2ND HIGHEST SALARY IN STRAIGHT TABLE.LIKE THIS

THIS IS MY STRAIGHT TABLE DATA.

ID NAME SALARY

2 KALYAN  20000

3 MANJU 23000

4 RAM  8000

5  SREEKAR 13000

I WROTE EXPRESSION IN EXPRESSION TAB LIKE THIS RANK(MAX(SALARY),2).BUT I DISPLAY  ABOVE TABLE ID LIKE THIS  1 BUT I WANT TO DISPLAY 2ND HIGHEST SALARY LIKE THIS  20000.PLS TELL ME OUT HOW TO DISPLAY LIKE THIS

ID  NAME SALARY

2   KALYAN  20000

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

like this

Regards,

Antonio

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

=Aggr(If(Sum(SALARY)>=Max(TOTAL Aggr(Sum(SALARY), Name), 4), Name), Name)

Also, if you don't need the total this expression can work avoiding calculated dimension:

If(Sum(Sales)>=Max(TOTAL Aggr(Sum(Name), Name), 4), Sum(Name))

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

Hi,

one solution could be:

hope this helps

regards

Marco

• ###### Re: HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

You need to write Calculated dimension  as

if(aggr(rank(sum(SALARY)),ID)=2,ID)

& Expression as Sum(SALARY)

Also Suppress the Null values of this Calculated Dimension. Hope This Helps

Regards

Abhishek