topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082356#M360576 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Sum(Aggr(Count(DISTINCT Customer), Month))</STRONG></P></BODY></HTML> Thu, 05 May 2016 15:46:39 GMT sunny_talwar 2016-05-05T15:46:39Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082355#M360575 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a data like this...</P><P></P><P>Customer&nbsp; Mointh&nbsp;&nbsp; Contact Name</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rajini</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vijay</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; March&nbsp;&nbsp;&nbsp;&nbsp; Ajith</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; April&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Surya</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shasha</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; March&nbsp;&nbsp;&nbsp;&nbsp; Divya</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; March&nbsp;&nbsp;&nbsp;&nbsp; Diya</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; April&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Diya</P><P></P><P>Now I want to show the running total based on customer.</P><P></P><P>Output should be : "Total Customer for all the three months" - 7 (I.e Feb - 2 distinct customers(A,B), March - 3 distinct customers (A, B, C) April - 2 distinct customers (A,C)..</P><P></P><P>If I select the Feb Month, Total no of customers should be 2 (A and B).</P><P></P><P>If I use count(Distinct Customer), 3 is showing for all the three months. But it should show 7.. If I remove distinct , it is counting the duplicate values. For ex in Feb month A customer data is there in two rows. SO it&nbsp; is showing the total for all the three months 8, If I select Feb Month it is showing 3 but it should show 2..</P><P></P><P>Can anyone please help me how to achieve this?</P></BODY></HTML> Thu, 05 May 2016 15:30:28 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082355#M360575 Anonymous 2016-05-05T15:30:28Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082356#M360576 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Sum(Aggr(Count(DISTINCT Customer), Month))</STRONG></P></BODY></HTML> Thu, 05 May 2016 15:46:39 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082356#M360576 sunny_talwar 2016-05-05T15:46:39Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082357#M360577 <HTML><HEAD></HEAD><BODY><P>Thanks a lot....</P></BODY></HTML> Thu, 05 May 2016 16:36:31 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1082357#M360577 Anonymous 2016-05-05T16:36:31Z