topic Percentile Reverse in QlikView

topic Percentile Reverse in QlikView https://community.qlik.com/t5/QlikView/Percentile-Reverse/m-p/451441#M168448 <HTML><HEAD></HEAD><BODY><P>How would qlikiview duplicate excels Function PErcentileRank =PERCENTRANK(B2:B8,13) = 50%</P><P></P><P>I know howe to get the Percentile from the fractile function. Is there a way to get the PercentRank the way excel calculates this?  </P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="20" style="border: black 0 solid;" width="64">ID</TD><TD style="border: black 0 solid;" width="64">Value</TD><TD style="border: black 0 solid;" width="103">PercentILE Excel Rank</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">7</TD><TD align="right" style="border: black 0 solid;">19</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">6</TD><TD align="right" style="border: black 0 solid;">15</TD><TD align="right" style="border: black 0 solid;">0.5</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">5</TD><TD align="right" style="border: black 0 solid;">14</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">4</TD><TD align="right" style="border: black 0 solid;">13</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">3</TD><TD align="right" style="border: black 0 solid;">12</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">2</TD><TD align="right" style="border: black 0 solid;">9</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">1</TD><TD align="right" style="border: black 0 solid;">8</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 19 Feb 2013 20:44:32 GMT 2013-02-19T20:44:32Z Percentile Reverse https://community.qlik.com/t5/QlikView/Percentile-Reverse/m-p/451441#M168448 <HTML><HEAD></HEAD><BODY><P>How would qlikiview duplicate excels Function PErcentileRank =PERCENTRANK(B2:B8,13) = 50%</P><P></P><P>I know howe to get the Percentile from the fractile function. Is there a way to get the PercentRank the way excel calculates this?  </P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="20" style="border: black 0 solid;" width="64">ID</TD><TD style="border: black 0 solid;" width="64">Value</TD><TD style="border: black 0 solid;" width="103">PercentILE Excel Rank</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">7</TD><TD align="right" style="border: black 0 solid;">19</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">6</TD><TD align="right" style="border: black 0 solid;">15</TD><TD align="right" style="border: black 0 solid;">0.5</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">5</TD><TD align="right" style="border: black 0 solid;">14</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">4</TD><TD align="right" style="border: black 0 solid;">13</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">3</TD><TD align="right" style="border: black 0 solid;">12</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">2</TD><TD align="right" style="border: black 0 solid;">9</TD></TR><TR><TD align="right" height="20" style="border: black 0 solid;">1</TD><TD align="right" style="border: black 0 solid;">8</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 19 Feb 2013 20:44:32 GMT https://community.qlik.com/t5/QlikView/Percentile-Reverse/m-p/451441#M168448 2013-02-19T20:44:32Z