topic cost distribution using aggr in QlikView https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153970#M376796 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Trying to create a cost distribution but aggregating the data.</P><P></P><P>I've attached my workings but I can't quite figure out the formula to use.</P><P></P><P>Note that in this file I have done a resident load to show you what I am trying to achieve but in reality this isn't feasible, it needs to work from formula on the raw data somehow.</P><P></P><P>I just can not sus it out</P></BODY></HTML> Wed, 27 Jul 2016 06:54:45 GMT adamdavi3s 2016-07-27T06:54:45Z cost distribution using aggr https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153970#M376796 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Trying to create a cost distribution but aggregating the data.</P><P></P><P>I've attached my workings but I can't quite figure out the formula to use.</P><P></P><P>Note that in this file I have done a resident load to show you what I am trying to achieve but in reality this isn't feasible, it needs to work from formula on the raw data somehow.</P><P></P><P>I just can not sus it out</P></BODY></HTML> Wed, 27 Jul 2016 06:54:45 GMT https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153970#M376796 adamdavi3s 2016-07-27T06:54:45Z Re: cost distribution using aggr https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153971#M376797 <HTML><HEAD></HEAD><BODY><P>Try to aggregate your cost in the advanced aggregation and perform a distinct count in the expression:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=aggr( round(sum([TOTAL COST])/500)*500 ,CUSTOMER)</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=count(DISTINCT CUSTOMER) / count(DISTINCT total CUSTOMER)</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><STRONG>100% </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">27%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">500</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">36%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1500</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">27%</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2000</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9%</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 27 Jul 2016 20:06:11 GMT https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153971#M376797 swuehl 2016-07-27T20:06:11Z Re: cost distribution using aggr https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153972#M376798 <HTML><HEAD></HEAD><BODY><P>I got so close to that yesterday! Not sure why I couldn't figure that one out,&nbsp; thank you swuehl</P></BODY></HTML> Thu, 28 Jul 2016 06:25:30 GMT https://community.qlik.com/t5/QlikView/cost-distribution-using-aggr/m-p/1153972#M376798 adamdavi3s 2016-07-28T06:25:30Z