topic Re: Aggr problems make me Aggr in QlikView https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953228#M327738 <HTML><HEAD></HEAD><BODY><P>Not sure if I understand completely, but may be this:</P><P></P><P><STRONG>Count(TOTAL Retailers)</STRONG></P></BODY></HTML> Fri, 23 Oct 2015 14:52:44 GMT sunny_talwar 2015-10-23T14:52:44Z Aggr problems make me Aggr https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953227#M327737 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I <SPAN style="font-size: 10pt;">am having some problems getting my the answers that I want.</SPAN></P><P></P><P><SPAN><SPAN>I have a total number of Retailers (164) and 15 stock groups (which are&nbsp; then split into groups of part numbers - current layout I am using is a Pivot Table with PartNo collapsed). Not all stock groups have had sales associated with each Retailer - in one column I want to put in the total number of Retailers in each row, so it associates 164 against every stock group.</SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>Then I want to show the sales of each stock group divided by the number of Retailers (To get a national average by stock group)</SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>I am really struggling here - I am sure I should be using Aggr, and have been going around in circles for a good couple of hours, but just can't figure it out!</SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>I hope someone can lend a helping hand?</SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>Thanks!</SPAN></SPAN></P><P></P><P></P><P></P></BODY></HTML> Fri, 23 Oct 2015 14:13:24 GMT https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953227#M327737 2015-10-23T14:13:24Z Re: Aggr problems make me Aggr https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953228#M327738 <HTML><HEAD></HEAD><BODY><P>Not sure if I understand completely, but may be this:</P><P></P><P><STRONG>Count(TOTAL Retailers)</STRONG></P></BODY></HTML> Fri, 23 Oct 2015 14:52:44 GMT https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953228#M327738 sunny_talwar 2015-10-23T14:52:44Z Re: Aggr problems make me Aggr https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953229#M327739 <HTML><HEAD></HEAD><BODY><P>COUNT(TOTAL <EM>DISTINCT</EM> Retailers)</P></BODY></HTML> Fri, 23 Oct 2015 14:58:04 GMT https://community.qlik.com/t5/QlikView/Aggr-problems-make-me-Aggr/m-p/953229#M327739 swuehl 2015-10-23T14:58:04Z