topic Re: Difference in using SUM and COUNT in QlikView https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317380#M1190039 <HTML><HEAD></HEAD><BODY><P>Hi Atitude,</P><P></P><P>Hope you got Correct Answer if you got please mark it as Correct Answer.</P><P></P><P>Anand</P></BODY></HTML> Fri, 29 Jul 2011 13:56:22 GMT its_anandrjs 2011-07-29T13:56:22Z Difference in using SUM and COUNT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317377#M1190036 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>What is the difference in using SUM and COUNT?</P><P></P><P>Regards</P><P></P><P>Attitude</P></BODY></HTML> Fri, 29 Jul 2011 11:28:41 GMT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317377#M1190036 2011-07-29T11:28:41Z Difference in using SUM and COUNT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317378#M1190037 <HTML><HEAD></HEAD><BODY><P> Let's say you have 3 records, value 10, 20 and 30.</P><P></P><P>Sum will give you the sum of the values = 60</P><P></P><P>Count will give you the count of the records = 3</P></BODY></HTML> Fri, 29 Jul 2011 11:38:51 GMT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317378#M1190037 mazacini 2011-07-29T11:38:51Z Re: Difference in using SUM and COUNT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317379#M1190038 <HTML><HEAD></HEAD><BODY><P>Hi Attitude,</P><P></P><P>Let Say You have different values and its values are 10,20,30. If you normal sum it it will be 60 but suppose the 20 value is distribute for different customer say. so if sum it it will different. Also see the sample file. And see difference between Distinct Sum, Distinct Count.</P><P></P><P></P><P>Anand</P></BODY></HTML> Fri, 29 Jul 2011 13:24:18 GMT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317379#M1190038 its_anandrjs 2011-07-29T13:24:18Z Re: Difference in using SUM and COUNT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317380#M1190039 <HTML><HEAD></HEAD><BODY><P>Hi Atitude,</P><P></P><P>Hope you got Correct Answer if you got please mark it as Correct Answer.</P><P></P><P>Anand</P></BODY></HTML> Fri, 29 Jul 2011 13:56:22 GMT https://community.qlik.com/t5/QlikView/Difference-in-using-SUM-and-COUNT/m-p/317380#M1190039 its_anandrjs 2011-07-29T13:56:22Z