HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

[#1]

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

MADHU

[rakesh_kumar]

Sum(Max(Salary,2))

[#3]

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.

[rakesh_kumar]

Hi Madhu,

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?

[antoniotiman]

Hi Madhu,

like this

Regards,

Antonio

[ramoncova06]

=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))

from Customers Having Top 4 Values

[#7]

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

THIS IS MY STRAIGHT TABLE DATA.

ID NAME SALARY

1 MADHU 15000

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

[antoniotiman]

Your need ?

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco

[#10]

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