topic HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW? in QlikView

HOW TO DISPLAY 2ND HIGHEST SALARY IN QLIKVIEW?

Wed, 03 Jun 2015 16:43:14 GMT

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

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

rakesh_kumar — Wed, 03 Jun 2015 16:47:47 GMT

Sum(Max(Salary,2))

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

Wed, 03 Jun 2015 17:01:13 GMT

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?

rakesh_kumar — Wed, 03 Jun 2015 17:09:01 GMT

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?

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

antoniotiman — Wed, 03 Jun 2015 17:09:13 GMT

Hi Madhu,

like this

Regards,

Antonio

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

ramoncova06 — Wed, 03 Jun 2015 17:17:32 GMT

=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

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

Wed, 03 Jun 2015 17:21:44 GMT

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

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

antoniotiman — Wed, 03 Jun 2015 18:09:19 GMT

Your need ?

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

MarcoWedel — Wed, 03 Jun 2015 18:26:31 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

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

Sun, 14 Jun 2015 10:59:57 GMT

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