topic Sum of duplicate values in QlikView https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233678#M85208 <HTML><HEAD></HEAD><BODY><P>Hi Anasb,</P><P>Here what you have to do is you just need to calculate the sum of amount by using "sum(distinct Amount)" . You are getting wrong aswer because all the sum is getting added if you do not use the distinct keyword. But the count function is working fine because you have distinct 4 numbers in you sum coloumn. Hope this helps you.</P><P>thanks .....Joseph<IMG alt="Cool" src="http://community.qlik.com/emoticons/emotion-11.gif" /></P></BODY></HTML> Thu, 06 May 2010 16:42:43 GMT 2010-05-06T16:42:43Z Sum of duplicate values https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233676#M85206 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a problem on qlikview wich start giving me headache !!</P><P>Heres my table :</P><P>Seller Amount<BR />A 121<BR />A 121<BR />A 121<BR />B 541<BR />B 630<BR />C 841</P><P>When i do sum(Amount) = 2133 and count(Amount) = 4, wich is obviously wrong ....</P><P>What would be the solution for suming duplicate values ?</P><P></P><P>Many many thanks in advance</P></BODY></HTML> Thu, 06 May 2010 15:34:34 GMT https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233676#M85206 2010-05-06T15:34:34Z Sum of duplicate values https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233677#M85207 <HTML><HEAD></HEAD><BODY><P>Are you sure about results you mentioned? See enclosed.</P></BODY></HTML> Thu, 06 May 2010 15:44:31 GMT https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233677#M85207 disqr_rm 2010-05-06T15:44:31Z Sum of duplicate values https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233678#M85208 <HTML><HEAD></HEAD><BODY><P>Hi Anasb,</P><P>Here what you have to do is you just need to calculate the sum of amount by using "sum(distinct Amount)" . You are getting wrong aswer because all the sum is getting added if you do not use the distinct keyword. But the count function is working fine because you have distinct 4 numbers in you sum coloumn. Hope this helps you.</P><P>thanks .....Joseph<IMG alt="Cool" src="http://community.qlik.com/emoticons/emotion-11.gif" /></P></BODY></HTML> Thu, 06 May 2010 16:42:43 GMT https://community.qlik.com/t5/QlikView/Sum-of-duplicate-values/m-p/233678#M85208 2010-05-06T16:42:43Z