topic Re: Issue with count formula in QlikView https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065228#M940941 <HTML><HEAD></HEAD><BODY><P>try this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>sum(TOTAL</STRONG> aggr(Count(DISTINCT Position),District, Month, <STRONG>Position</STRONG>))</SPAN></P></BODY></HTML> Mon, 25 Jan 2016 12:15:33 GMT 2016-01-25T12:15:33Z Issue with count formula https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065227#M940940 <HTML><HEAD></HEAD><BODY><P>Dear colleagues,</P><P></P><P>I am trying to achieve allocation of total territory's sales among of representatives that are covering it. For example, I have 3 representatives A1, A2, A2 on a terriotry A and sales are equal to 10. If I just drop position as dimension, I get total territory sales across each position:</P><P><IMG alt="1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112459_1.jpg" style="height: auto;" /></P><P>To fix that, I want to count number of positions covering this territory and divide total territory sales by number of positions. For that I tried below formula: =max(aggr(Count(DISTINCT Position),District, Month)), it works well only for the first position, the remaining positions are supressed:</P><P></P><P><IMG alt="2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/112460_2.jpg" style="height: auto;" /></P><P>Could you please help to understand why I am not able to achieve the desired result?</P><P></P><P>Many thanks in advance.</P><P></P><P>P.S. I am also attaching QV sample file.</P></BODY></HTML> Mon, 25 Jan 2016 11:49:02 GMT https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065227#M940940 2016-01-25T11:49:02Z Re: Issue with count formula https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065228#M940941 <HTML><HEAD></HEAD><BODY><P>try this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>sum(TOTAL</STRONG> aggr(Count(DISTINCT Position),District, Month, <STRONG>Position</STRONG>))</SPAN></P></BODY></HTML> Mon, 25 Jan 2016 12:15:33 GMT https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065228#M940941 2016-01-25T12:15:33Z Re: Issue with count formula https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065229#M940942 <HTML><HEAD></HEAD><BODY><P>Or maybe</P><P></P><P>=Sum(<STRONG>TOTAL&lt;District,Month&gt;</STRONG> aggr(1 ,District, Month,Position))</P></BODY></HTML> Mon, 25 Jan 2016 12:22:06 GMT https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065229#M940942 swuehl 2016-01-25T12:22:06Z Re: Issue with count formula https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065230#M940943 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, that was quick!</P></BODY></HTML> Mon, 25 Jan 2016 12:24:03 GMT https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065230#M940943 2016-01-25T12:24:03Z Re: Issue with count formula https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065231#M940944 <HTML><HEAD></HEAD><BODY><P>How are you not an MVP stefan <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 25 Jan 2016 12:26:33 GMT https://community.qlik.com/t5/QlikView/Issue-with-count-formula/m-p/1065231#M940944 2016-01-25T12:26:33Z