topic average fractile in QlikView https://community.qlik.com/t5/QlikView/average-fractile/m-p/1425281#M429387 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I am using the fractile function to find out my 95th percentile and then using that I am average the top 95 percent,</P><P></P><P>Using the function. <STRONG>=Avg(Aggr(If(Counter &lt; Fractile(Total&nbsp; &lt;MetricName&gt; Counter,0.95),Counter),MetricName,ID)).</STRONG></P><P><STRONG><BR /></STRONG></P><P>this function returns 832 as my 95th percentile</P><P></P><P><IMG alt="d.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177883_d.PNG" style="height: auto;" /></P><P>but the avg displayed in the chart is <STRONG>266</STRONG> which is not correct I need <STRONG>261.</STRONG></P><P><STRONG><BR /></STRONG></P><P>but using the expression <SPAN style="font-size: 13.3333px;"> </SPAN><STRONG style="font-size: 13.3333px;">=Avg(Aggr(If(Counter &lt; 832,Counter),MetricName,ID)) </STRONG>gives me the correct result, but as a function as whole does evaluate</P><P></P><P></P><P>Please help, attached the excel as well</P></BODY></HTML> Wed, 27 Sep 2017 13:16:10 GMT 2017-09-27T13:16:10Z average fractile https://community.qlik.com/t5/QlikView/average-fractile/m-p/1425281#M429387 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I am using the fractile function to find out my 95th percentile and then using that I am average the top 95 percent,</P><P></P><P>Using the function. <STRONG>=Avg(Aggr(If(Counter &lt; Fractile(Total&nbsp; &lt;MetricName&gt; Counter,0.95),Counter),MetricName,ID)).</STRONG></P><P><STRONG><BR /></STRONG></P><P>this function returns 832 as my 95th percentile</P><P></P><P><IMG alt="d.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177883_d.PNG" style="height: auto;" /></P><P>but the avg displayed in the chart is <STRONG>266</STRONG> which is not correct I need <STRONG>261.</STRONG></P><P><STRONG><BR /></STRONG></P><P>but using the expression <SPAN style="font-size: 13.3333px;"> </SPAN><STRONG style="font-size: 13.3333px;">=Avg(Aggr(If(Counter &lt; 832,Counter),MetricName,ID)) </STRONG>gives me the correct result, but as a function as whole does evaluate</P><P></P><P></P><P>Please help, attached the excel as well</P></BODY></HTML> Wed, 27 Sep 2017 13:16:10 GMT https://community.qlik.com/t5/QlikView/average-fractile/m-p/1425281#M429387 2017-09-27T13:16:10Z