topic Re: Percentile Calculation in QlikView https://community.qlik.com/t5/QlikView/Percentile-Calculation/m-p/551631#M206046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach some sample qlikview file.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 30 Aug 2013 01:57:35 GMT jagan 2013-08-30T01:57:35Z Percentile Calculation https://community.qlik.com/t5/QlikView/Percentile-Calculation/m-p/551630#M206045 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I wish to calculate the Percentile for a dashboard. I know we can use the Fractile to calculate the percentile.</P><P>But I need the Percentile to match the way our user calculates it, the way our user calculates it is</P><P></P><P>Percentile = (Count of all the scores below current score) / (Total Count).</P><P></P><P>Now if two rows have the same score then we should only consider the scores below the current score.</P><P></P><P>I am not sure if Fractile can do that, kindly suggest</P><P></P><P>Thanks in advance</P><P><STRONG>Amar</STRONG></P></BODY></HTML> Fri, 30 Aug 2013 01:47:21 GMT https://community.qlik.com/t5/QlikView/Percentile-Calculation/m-p/551630#M206045 amars 2013-08-30T01:47:21Z Re: Percentile Calculation https://community.qlik.com/t5/QlikView/Percentile-Calculation/m-p/551631#M206046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach some sample qlikview file.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 30 Aug 2013 01:57:35 GMT https://community.qlik.com/t5/QlikView/Percentile-Calculation/m-p/551631#M206046 jagan 2013-08-30T01:57:35Z