topic Re: Fractile and average in QlikView https://community.qlik.com/t5/QlikView/Fractile-and-average/m-p/1076084#M358956 <HTML><HEAD></HEAD><BODY><P>from the syntax point of view I think you need an advanced aggr, maybe something like</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>Fractile( aggr(avg(sales), somefield),0.95)</EM></SPAN></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">this is from the Qlik help</SPAN></P><P class="syntax"><A name="kanchor1144"></A><A name="fractile"></A><SPAN class="Bold"><EM>fractile (</EM></SPAN><EM><SPAN class="Italic">[{set_expression}] [ <SPAN class="Bold">distinct</SPAN> ] [ <SPAN class="Bold">total</SPAN> [&lt;fld {,fld}&gt;] ] expression, fractile</SPAN><SPAN class="Bold">)</SPAN> </EM></P><P><EM>returns the aggregated fractile of <SPAN class="Italic">expression</SPAN> iterated over the chart dimension(s). </EM></P><P><EM>The function argument expressions must not contain aggregation functions, unless these inner aggregations contain the <SPAN class="Bold">total</SPAN> qualifier. For more advanced nested aggregations, please use the <A class="xref_1">Advanced Aggregation</A> function in combination with calculated dimensions, see <A class="xref_1">Add calculated dimension... </A>. </EM></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Tue, 26 Jan 2016 18:55:44 GMT maxgro 2016-01-26T18:55:44Z Fractile and average https://community.qlik.com/t5/QlikView/Fractile-and-average/m-p/1076083#M358955 <HTML><HEAD></HEAD><BODY><P>I want to do Fractile(avg(sales),0.95). But this expressions doesnt seem to work. </P><P>can someone tell me whats wrong here?</P><P></P><P>Any help is appreciated.</P><P>Thanks.</P></BODY></HTML> Tue, 26 Jan 2016 18:47:39 GMT https://community.qlik.com/t5/QlikView/Fractile-and-average/m-p/1076083#M358955 rdsuperlike 2016-01-26T18:47:39Z Re: Fractile and average https://community.qlik.com/t5/QlikView/Fractile-and-average/m-p/1076084#M358956 <HTML><HEAD></HEAD><BODY><P>from the syntax point of view I think you need an advanced aggr, maybe something like</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>Fractile( aggr(avg(sales), somefield),0.95)</EM></SPAN></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">this is from the Qlik help</SPAN></P><P class="syntax"><A name="kanchor1144"></A><A name="fractile"></A><SPAN class="Bold"><EM>fractile (</EM></SPAN><EM><SPAN class="Italic">[{set_expression}] [ <SPAN class="Bold">distinct</SPAN> ] [ <SPAN class="Bold">total</SPAN> [&lt;fld {,fld}&gt;] ] expression, fractile</SPAN><SPAN class="Bold">)</SPAN> </EM></P><P><EM>returns the aggregated fractile of <SPAN class="Italic">expression</SPAN> iterated over the chart dimension(s). </EM></P><P><EM>The function argument expressions must not contain aggregation functions, unless these inner aggregations contain the <SPAN class="Bold">total</SPAN> qualifier. For more advanced nested aggregations, please use the <A class="xref_1">Advanced Aggregation</A> function in combination with calculated dimensions, see <A class="xref_1">Add calculated dimension... </A>. </EM></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Tue, 26 Jan 2016 18:55:44 GMT https://community.qlik.com/t5/QlikView/Fractile-and-average/m-p/1076084#M358956 maxgro 2016-01-26T18:55:44Z