topic Re: PERCENTRANK in QlikView https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450798#M168245 <HTML><HEAD></HEAD><BODY><P>These do not give the result that I showed in my example above</P></BODY></HTML> Tue, 19 Feb 2013 17:17:22 GMT 2013-02-19T17:17:22Z PERCENTRANK https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450796#M168243 <HTML><HEAD></HEAD><BODY><P>How would qlikiview duplicate&nbsp; excels Function PErcentileRank =PERCENTRANK(B2:B8,13)</P><P></P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 295px;"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">Value</TD><TD width="103">PercentILE Excel Rank</TD></TR><TR><TD align="right" height="20">7</TD><TD align="right">19</TD></TR><TR><TD align="right" height="20">6</TD><TD align="right">15</TD><TD align="right">0.5</TD></TR><TR><TD align="right" height="20">5</TD><TD align="right">14</TD></TR><TR><TD align="right" height="20">4</TD><TD align="right">13</TD></TR><TR><TD align="right" height="20">3</TD><TD align="right">12</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right">9</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">8</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 19 Feb 2013 17:02:47 GMT https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450796#M168243 2013-02-19T17:02:47Z Re: PERCENTRANK https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450797#M168244 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">=Fractile(Aggr(Value,Dim,Value), 0.13)</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">or you looking for rank function</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">rank( sum( Sales ))</P></BODY></HTML> Tue, 19 Feb 2013 17:12:06 GMT https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450797#M168244 jagannalla 2013-02-19T17:12:06Z Re: PERCENTRANK https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450798#M168245 <HTML><HEAD></HEAD><BODY><P>These do not give the result that I showed in my example above</P></BODY></HTML> Tue, 19 Feb 2013 17:17:22 GMT https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450798#M168245 2013-02-19T17:17:22Z Re: PERCENTRANK https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450799#M168246 <HTML><HEAD></HEAD><BODY><P>Im looking for ReverseFractile, Which is what PercentRank in Excel is</P></BODY></HTML> Tue, 19 Feb 2013 17:31:17 GMT https://community.qlik.com/t5/QlikView/PERCENTRANK/m-p/450799#M168246 2013-02-19T17:31:17Z