topic Re: EXCEL Like Function in Qlikview in QlikView https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450762#M168239 <HTML><HEAD></HEAD><BODY><P>=Fractile(Aggr(Value,Dim,Value), 0.25)</P><P></P><P>or you looking for rank function</P><P></P><P>rank( sum( Sales ))</P></BODY></HTML> Tue, 19 Feb 2013 17:11:40 GMT jagannalla 2013-02-19T17:11:40Z EXCEL Like Function in Qlikview https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450758#M168235 <HTML><HEAD></HEAD><BODY><P>Can someone Help me replicate the Excel Function&nbsp;&nbsp; PERCENTILE in Qlikview</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Excel Function =PERCENTILE(B2:B8,0.8)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="295"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">Value</TD><TD width="103">PercentILE Excel Returns</TD></TR><TR><TD align="right" height="20">7</TD><TD align="right">19</TD><TD align="right">14.8</TD></TR><TR><TD align="right" height="20">6</TD><TD align="right">15</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 16:22:53 GMT https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450758#M168235 2013-02-19T16:22:53Z Re: EXCEL Like Function in Qlikview https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450759#M168236 <HTML><HEAD></HEAD><BODY><P>fractile( Sales, 0.75 )</P></BODY></HTML> Tue, 19 Feb 2013 16:33:32 GMT https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450759#M168236 jagannalla 2013-02-19T16:33:32Z Re: EXCEL Like Function in Qlikview https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450760#M168237 <HTML><HEAD></HEAD><BODY><P>How about PercentileRank ?</P></BODY></HTML> Tue, 19 Feb 2013 16:55:02 GMT https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450760#M168237 2013-02-19T16:55:02Z Re: EXCEL Like Function in Qlikview https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450761#M168238 <HTML><HEAD></HEAD><BODY><P>How about PercentileRank ?</P></BODY></HTML> Tue, 19 Feb 2013 16:55:05 GMT https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450761#M168238 2013-02-19T16:55:05Z Re: EXCEL Like Function in Qlikview https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450762#M168239 <HTML><HEAD></HEAD><BODY><P>=Fractile(Aggr(Value,Dim,Value), 0.25)</P><P></P><P>or you looking for rank function</P><P></P><P>rank( sum( Sales ))</P></BODY></HTML> Tue, 19 Feb 2013 17:11:40 GMT https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450762#M168239 jagannalla 2013-02-19T17:11:40Z Re: EXCEL Like Function in Qlikview https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450763#M168240 <HTML><HEAD></HEAD><BODY><P>This does not come up with PercentRank from Excel. If you look at the above table and values I am looking for the exact value that excel returns in the formulas. </P></BODY></HTML> Tue, 19 Feb 2013 17:22:10 GMT https://community.qlik.com/t5/QlikView/EXCEL-Like-Function-in-Qlikview/m-p/450763#M168240 2013-02-19T17:22:10Z