topic Accumulation in QlikView https://community.qlik.com/t5/QlikView/Accumulation/m-p/598218#M221495 <HTML><HEAD></HEAD><BODY><P>Good day Experts,</P><P></P><P>Please could you advise on the following. </P><P>On day1 I receive 95427 connections</P><P>On day2 I receive 97935 connections</P><P>On day3 I receive 100868 connections. </P><P></P><P>Of the 97935 connections I receive on day2 2720 connections do not exist in day1 and overall the distinct connections for the 2 days<BR />would be 95427 + 2720 = 98147, then on day3 there are 3174 new connections and the distinct connections over the 3 days would be</P><P>98147 + 3174 = 101321.</P><P></P><P>How would I be abale to achieve this?</P></BODY></HTML> Tue, 04 Mar 2014 13:58:22 GMT kamielrajaram 2014-03-04T13:58:22Z Accumulation https://community.qlik.com/t5/QlikView/Accumulation/m-p/598218#M221495 <HTML><HEAD></HEAD><BODY><P>Good day Experts,</P><P></P><P>Please could you advise on the following. </P><P>On day1 I receive 95427 connections</P><P>On day2 I receive 97935 connections</P><P>On day3 I receive 100868 connections. </P><P></P><P>Of the 97935 connections I receive on day2 2720 connections do not exist in day1 and overall the distinct connections for the 2 days<BR />would be 95427 + 2720 = 98147, then on day3 there are 3174 new connections and the distinct connections over the 3 days would be</P><P>98147 + 3174 = 101321.</P><P></P><P>How would I be abale to achieve this?</P></BODY></HTML> Tue, 04 Mar 2014 13:58:22 GMT https://community.qlik.com/t5/QlikView/Accumulation/m-p/598218#M221495 kamielrajaram 2014-03-04T13:58:22Z Re: Accumulation https://community.qlik.com/t5/QlikView/Accumulation/m-p/598219#M221496 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone have any ideas about this?</P></BODY></HTML> Thu, 27 Mar 2014 10:47:50 GMT https://community.qlik.com/t5/QlikView/Accumulation/m-p/598219#M221496 kamielrajaram 2014-03-27T10:47:50Z