topic Fractile %'s...How to make work? in QlikView https://community.qlik.com/t5/QlikView/Fractile-s-How-to-make-work/m-p/156784#M32525 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to a create a chart that will show the number of customers by the volume over Quarters...I've tried using the fractile function and can't get it to work...</P><P>Data Looks like this...</P><P>I want to see the number of customers that make up the 25%,50%, and 75% fractiles...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 233pt; border-collapse: collapse;" width="310"><COLGROUP><COL style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986; mso-outline-parent: collapsed;" width="109" /><COL style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766; mso-outline-parent: collapsed;" width="103" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="border-right: gainsboro 1pt solid; border-top: gainsboro 1pt solid; border-left: gainsboro 0.5pt solid; width: 82pt; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: #ebebeb;" width="109"><STRONG>ShipDate.Year - Quarter</STRONG></TD><TD class="xl64" style="width: 77pt; background-color: white; border: gainsboro 0.5pt solid;" width="103">Customer Count</TD><TD class="xl64" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 74pt; border-bottom: gainsboro 0.5pt solid; background-color: white;" width="98"># of Orders</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q4</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">685</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">35087</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q2</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">659</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">35252</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q3</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">657</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">33169</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q1</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">576</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">29379</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Thanks for looking and any help would be greatly appreciated.</P></BODY></HTML> Tue, 23 Feb 2010 21:10:06 GMT 2010-02-23T21:10:06Z Fractile %'s...How to make work? https://community.qlik.com/t5/QlikView/Fractile-s-How-to-make-work/m-p/156784#M32525 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to a create a chart that will show the number of customers by the volume over Quarters...I've tried using the fractile function and can't get it to work...</P><P>Data Looks like this...</P><P>I want to see the number of customers that make up the 25%,50%, and 75% fractiles...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 233pt; border-collapse: collapse;" width="310"><COLGROUP><COL style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986; mso-outline-parent: collapsed;" width="109" /><COL style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766; mso-outline-parent: collapsed;" width="103" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="border-right: gainsboro 1pt solid; border-top: gainsboro 1pt solid; border-left: gainsboro 0.5pt solid; width: 82pt; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: #ebebeb;" width="109"><STRONG>ShipDate.Year - Quarter</STRONG></TD><TD class="xl64" style="width: 77pt; background-color: white; border: gainsboro 0.5pt solid;" width="103">Customer Count</TD><TD class="xl64" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 74pt; border-bottom: gainsboro 0.5pt solid; background-color: white;" width="98"># of Orders</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q4</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">685</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">35087</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q2</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">659</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">35252</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q3</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">657</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">33169</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;">2009-Q1</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">576</TD><TD align="right" class="xl65" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">29379</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Thanks for looking and any help would be greatly appreciated.</P></BODY></HTML> Tue, 23 Feb 2010 21:10:06 GMT https://community.qlik.com/t5/QlikView/Fractile-s-How-to-make-work/m-p/156784#M32525 2010-02-23T21:10:06Z