topic Sum Distinct problem in QlikView https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164414#M37110 <HTML><HEAD></HEAD><BODY><P></P><P></P><P></P><P>This is the correct formula but thanks for the help!</P><P>=</P><P><B>SUM</B>(<B>AGGR</B>(<B>SUM</B>(<B>DISTINCT</B> <B>Quata</B>), <B>[SalesPerson]</B>,<B>Quarter</B>))</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 17 Aug 2010 14:46:11 GMT timmy 2010-08-17T14:46:11Z Sum Distinct problem https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164411#M37107 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>I have a problem with this formula:</P><P>sum(distint Quata)</P><P>The dimension in the tabel is Salesperson and the problem is that we have two the same Quata's</P><P>Example:</P><P>SalesP1 650<BR />SalesP2 650</P><P>If you take the formula sum(Distinct Quata) for this example you get 650 as total...</P><P>How can i solve this?</P><P>greetings</P></BODY></HTML> Tue, 17 Aug 2010 14:21:56 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164411#M37107 timmy 2010-08-17T14:21:56Z Sum Distinct problem https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164412#M37108 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My suggest:</P><P>SUM(TOTAL AGGR(SUM(DISTINCT Quata), Salesperson))</P></BODY></HTML> Tue, 17 Aug 2010 14:34:14 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164412#M37108 2010-08-17T14:34:14Z Sum Distinct problem https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164413#M37109 <HTML><HEAD></HEAD><BODY><P>That's right, because of DISTINCT. It group the data first and does the SUM() after that. Use sum(Quata) to get 1300.</P></BODY></HTML> Tue, 17 Aug 2010 14:36:57 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164413#M37109 2010-08-17T14:36:57Z Sum Distinct problem https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164414#M37110 <HTML><HEAD></HEAD><BODY><P></P><P></P><P></P><P>This is the correct formula but thanks for the help!</P><P>=</P><P><B>SUM</B>(<B>AGGR</B>(<B>SUM</B>(<B>DISTINCT</B> <B>Quata</B>), <B>[SalesPerson]</B>,<B>Quarter</B>))</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 17 Aug 2010 14:46:11 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-problem/m-p/164414#M37110 timmy 2010-08-17T14:46:11Z