topic Re: AGGR/fractile - dimension problem in QlikView https://community.qlik.com/t5/QlikView/AGGR-fractile-dimension-problem/m-p/973318#M646006 <HTML><HEAD></HEAD><BODY><P>Use an expression like</P><P>=fractile(total&lt;Department, Product&gt; Revenue/Quantity,0.75)</P><P></P><P>in a straight table with above dimensions (Departement, Product, Quantitiy, Revenue) or detail what your dimensions and expressions are.</P><P></P><P>edit: Using price calculation</P></BODY></HTML> Tue, 10 Nov 2015 21:04:36 GMT swuehl 2015-11-10T21:04:36Z AGGR/fractile - dimension problem https://community.qlik.com/t5/QlikView/AGGR-fractile-dimension-problem/m-p/973317#M646005 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I got a table with lots of prices which I calculate by the revenue and the quantity. Now I want to split theses prices by the fractile function and aggregate them by one or two dimensions (product (and department)).</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Department</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Revenue</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Price</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>q(75%)</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">120</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">67,50</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">210</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">67,50</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">17</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">17</TD><TD style="padding: 2px;">19,25</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">19,25</TD></TR></TBODY></TABLE><P></P><P>It should look like that but I don't know how to do it.</P><P></P><P>Thanks a lot,</P><P>Matthias</P></BODY></HTML> Tue, 10 Nov 2015 19:57:14 GMT https://community.qlik.com/t5/QlikView/AGGR-fractile-dimension-problem/m-p/973317#M646005 mys-elf 2015-11-10T19:57:14Z Re: AGGR/fractile - dimension problem https://community.qlik.com/t5/QlikView/AGGR-fractile-dimension-problem/m-p/973318#M646006 <HTML><HEAD></HEAD><BODY><P>Use an expression like</P><P>=fractile(total&lt;Department, Product&gt; Revenue/Quantity,0.75)</P><P></P><P>in a straight table with above dimensions (Departement, Product, Quantitiy, Revenue) or detail what your dimensions and expressions are.</P><P></P><P>edit: Using price calculation</P></BODY></HTML> Tue, 10 Nov 2015 21:04:36 GMT https://community.qlik.com/t5/QlikView/AGGR-fractile-dimension-problem/m-p/973318#M646006 swuehl 2015-11-10T21:04:36Z