topic percentile calculation in QlikView https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234559#M85969 <HTML><HEAD></HEAD><BODY><P>Hi Sunil,</P><P>A <B>percentile</B> (or centile) is the value of a variable below which a certain percent of observations fall. So the 20th percentile is the value (or score) below which 20 percent of the observations may be found.</P><P>*****************************</P><P>Suppose 100 people take a test of 50 items.<BR /><BR />If one of them got 40 of the items correct, then the percentage that he got correct is 80. He got 80 percent of the items correct.<BR /><BR />But we don't know what percentile he is in until we see what scores the other 99 people got.<BR /><BR />Suppose that all 99 of those other people got only 60% (or fewer) of the items correct. Then the person who got 80% did better than all other 99 people. He did better than 99% of the whole group of 100, so he is in the 99th percentile.<BR /><BR />Hope this would help you understand.</P><P>regards, tresesco</P></BODY></HTML> Wed, 29 Dec 2010 06:19:02 GMT tresB 2010-12-29T06:19:02Z percentile calculation https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234558#M85968 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>how to calculate percentile?</P><P>what is difference between percentage and percentile.</P><P>plaese provide me examples if any.</P><P></P><P>Regards</P><P>Tom</P></BODY></HTML> Wed, 29 Dec 2010 06:06:09 GMT https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234558#M85968 SunilChauhan 2010-12-29T06:06:09Z percentile calculation https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234559#M85969 <HTML><HEAD></HEAD><BODY><P>Hi Sunil,</P><P>A <B>percentile</B> (or centile) is the value of a variable below which a certain percent of observations fall. So the 20th percentile is the value (or score) below which 20 percent of the observations may be found.</P><P>*****************************</P><P>Suppose 100 people take a test of 50 items.<BR /><BR />If one of them got 40 of the items correct, then the percentage that he got correct is 80. He got 80 percent of the items correct.<BR /><BR />But we don't know what percentile he is in until we see what scores the other 99 people got.<BR /><BR />Suppose that all 99 of those other people got only 60% (or fewer) of the items correct. Then the person who got 80% did better than all other 99 people. He did better than 99% of the whole group of 100, so he is in the 99th percentile.<BR /><BR />Hope this would help you understand.</P><P>regards, tresesco</P></BODY></HTML> Wed, 29 Dec 2010 06:19:02 GMT https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234559#M85969 tresB 2010-12-29T06:19:02Z percentile calculation https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234560#M85970 <HTML><HEAD></HEAD><BODY><P>To compute percentiles in QlikView, use the fractile() function. Fractile(Score,0.50) is the same as median(Score). Fractile(Score,0.90) is the 90th percentile.</P></BODY></HTML> Thu, 30 Dec 2010 02:44:38 GMT https://community.qlik.com/t5/QlikView/percentile-calculation/m-p/234560#M85970 johnw 2010-12-30T02:44:38Z