topic Percentile calculation in QlikView https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995742#M955464 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to calculate Salary range percentile for employees. How can this be achieved ?</P><P>Please provide me examples on this.</P><P></P><P>Regards.</P></BODY></HTML> Sat, 14 Nov 2015 13:58:53 GMT 2015-11-14T13:58:53Z Percentile calculation https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995742#M955464 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to calculate Salary range percentile for employees. How can this be achieved ?</P><P>Please provide me examples on this.</P><P></P><P>Regards.</P></BODY></HTML> Sat, 14 Nov 2015 13:58:53 GMT https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995742#M955464 2015-11-14T13:58:53Z Re: Percentile calculation https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995743#M955465 <HTML><HEAD></HEAD><BODY><P>Fractile( Salary, 0.75 )</P><P></P><P>will calculate the 75% fractile of the field Salary.</P><P></P><P>HIC</P></BODY></HTML> Sat, 14 Nov 2015 17:04:58 GMT https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995743#M955465 hic 2015-11-14T17:04:58Z Re: Percentile calculation https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995744#M955466 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Like this..?</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14475231034094799" jivemacro_uid="_14475231034094799"> <P>SAL:</P> <P>LOAD *,Num((Sal_Off_Min_Diff/Max_MinDiff)*100,'#,##0.00') as Percentile;</P> <P>LOAD *,</P> <P>&nbsp; [Max Salary]-[Min Salary] as Max_MinDiff,</P> <P>&nbsp; [Salary Offered]-[Min Salary] as Sal_Off_Min_Diff</P> <P> INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Min Salary, Max Salary, Salary Offered</P> <P>&nbsp;&nbsp;&nbsp; 76000, 95000, 80000</P> <P>&nbsp;&nbsp;&nbsp; 34000, 45000, 43000</P> <P>&nbsp;&nbsp;&nbsp; 36831, 55500, 40422</P> <P>&nbsp;&nbsp;&nbsp; 77000, 94000, 78000</P> <P>];</P> </PRE><P></P><P>Result:</P><P><IMG alt="Picture1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105510_Picture1.jpg" style="height: 137px; width: 620px;" /></P></BODY></HTML> Sat, 14 Nov 2015 17:49:20 GMT https://community.qlik.com/t5/QlikView/Percentile-calculation/m-p/995744#M955466 settu_periasamy 2015-11-14T17:49:20Z