topic Re: Fractile with Calculated Field?? in QlikView https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441583#M1156808 <HTML><HEAD></HEAD><BODY><P>It seems a bit illogical (in QV terms) the way you've stated it. Count(distinct purchases) is a single value for each row. A single value can't have a fractile. </P><P></P><P>Do you want the fractile of the 5 aggregated line values (50,25,15,2,8)? If so, try </P><P></P><P><SPAN style="font-family: 'courier new', courier;">=fractile(TOTAL aggr(count(DISTINCT purchases),[Customer Name]),.25)</SPAN></P><P></P><P>-Rob</P></BODY></HTML> Fri, 15 Feb 2013 22:55:28 GMT rwunderlich 2013-02-15T22:55:28Z Fractile with Calculated Field?? https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441582#M1156807 <HTML><HEAD></HEAD><BODY><P>Hey guys, I have a question around using fractiles with calculated fields.&nbsp; I want to do fractile(NumberofPurchases,.25) but that does not work and neither does fractile(count(distinct(purchases)),.25).&nbsp; Help?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="203" style="border: 1px solid rgb(0, 0, 0); width: 345px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">Customer Name</TH><TH align="center" style="background-color: #6690bc;" valign="middle">NumberofPurchases<BR /></TH></TR><TR><TD><BR /></TD><TD>count(distinct(purchases))</TD></TR><TR><TD><P>Name 1</P></TD><TD>50</TD></TR><TR><TD>Name 2</TD><TD>25</TD></TR><TR><TD>Name 3</TD><TD>15</TD></TR><TR><TD>Name 4</TD><TD>2</TD></TR><TR><TD>Name 5</TD><TD>8</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 15 Feb 2013 21:03:18 GMT https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441582#M1156807 2013-02-15T21:03:18Z Re: Fractile with Calculated Field?? https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441583#M1156808 <HTML><HEAD></HEAD><BODY><P>It seems a bit illogical (in QV terms) the way you've stated it. Count(distinct purchases) is a single value for each row. A single value can't have a fractile. </P><P></P><P>Do you want the fractile of the 5 aggregated line values (50,25,15,2,8)? If so, try </P><P></P><P><SPAN style="font-family: 'courier new', courier;">=fractile(TOTAL aggr(count(DISTINCT purchases),[Customer Name]),.25)</SPAN></P><P></P><P>-Rob</P></BODY></HTML> Fri, 15 Feb 2013 22:55:28 GMT https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441583#M1156808 rwunderlich 2013-02-15T22:55:28Z Re: Fractile with Calculated Field?? https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441584#M1156809 <HTML><HEAD></HEAD><BODY><P>Thank you - this wasn't just the right answer, it was the perfect answer.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 16 Feb 2013 04:53:56 GMT https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441584#M1156809 2013-02-16T04:53:56Z Re: Fractile with Calculated Field?? https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441585#M1156810 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Please help me.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I have exam data of a class of 50 students.</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Now I want to calculate the <STRONG>average (and, median) of top 80% students</STRONG> of that class.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">How can I do that?<BR />Please help.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Thanks.</P></BODY></HTML> Sat, 10 Aug 2013 18:24:42 GMT https://community.qlik.com/t5/QlikView/Fractile-with-Calculated-Field/m-p/441585#M1156810 2013-08-10T18:24:42Z