topic Re: How to find second highest salary in QlikView https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213683#M864550 <HTML><HEAD></HEAD><BODY><P>Use the below script in Calculated dimension and use Sum(Salary) in Expression</P><P><SPAN style="font-size: 13.3333px;">If(Aggr(Rank(Sum(Salary),Employee)=1,Employee)</SPAN></P><P></P><P>Or you can use dimension limits Tab, do the below thing</P><P></P><P><IMG alt="sal.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/147216_sal.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 21 Dec 2016 06:16:39 GMT 2016-12-21T06:16:39Z How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213679#M864546 <HTML><HEAD></HEAD><BODY><P>Hi how find second&nbsp; highest salary in qlikview </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213679#M864546 gkcchowdary 2020-11-25T16:16:04Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213680#M864547 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P>max(salary,2) // gives as per selection</P><P>or </P><P>Max({1}salary,2)</P></BODY></HTML> Wed, 21 Dec 2016 05:23:14 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213680#M864547 avinashelite 2016-12-21T05:23:14Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213681#M864548 <HTML><HEAD></HEAD><BODY><P>In your expression, try:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Salary</SPAN><SPAN style="font-size: 8pt;">={'=rank(sum(Salary))=2'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Salary</SPAN><SPAN style="font-size: 8pt;">)<BR /> </SPAN></P></BODY></HTML> Wed, 21 Dec 2016 05:37:04 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213681#M864548 Anonymous 2016-12-21T05:37:04Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213682#M864549 <HTML><HEAD></HEAD><BODY><P>See attached</P></BODY></HTML> Wed, 21 Dec 2016 05:39:55 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213682#M864549 Anonymous 2016-12-21T05:39:55Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213683#M864550 <HTML><HEAD></HEAD><BODY><P>Use the below script in Calculated dimension and use Sum(Salary) in Expression</P><P><SPAN style="font-size: 13.3333px;">If(Aggr(Rank(Sum(Salary),Employee)=1,Employee)</SPAN></P><P></P><P>Or you can use dimension limits Tab, do the below thing</P><P></P><P><IMG alt="sal.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/147216_sal.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 21 Dec 2016 06:16:39 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213683#M864550 2016-12-21T06:16:39Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213684#M864551 <HTML><HEAD></HEAD><BODY><P>Look into FirstSortedValue() function....</P></BODY></HTML> Wed, 21 Dec 2016 06:18:58 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213684#M864551 trdandamudi 2016-12-21T06:18:58Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213685#M864552 <HTML><HEAD></HEAD><BODY><P>Use into expression,</P><P></P><P>If(rank(sum(Salary))=2,sum(Salary),0)</P></BODY></HTML> Wed, 21 Dec 2016 11:44:06 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213685#M864552 muthukumar77 2016-12-21T11:44:06Z Re: How to find second highest salary https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213686#M864553 <HTML><HEAD></HEAD><BODY><P>You can try:</P><P>=FirstSortedValue(Sal, aggr(rank(sum(Sal)),Name), 2)</P></BODY></HTML> Wed, 21 Dec 2016 12:09:43 GMT https://community.qlik.com/t5/QlikView/How-to-find-second-highest-salary/m-p/1213686#M864553 2016-12-21T12:09:43Z