topic Re: Showing cumulative sum while adding and deleting records in QlikView https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401776#M797079 <HTML><HEAD></HEAD><BODY><P>Does this looks like what you are looking to get?</P><P></P><P><IMG __jive_id="187026" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187026_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 14 Dec 2017 16:23:54 GMT sunny_talwar 2017-12-14T16:23:54Z Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401773#M797076 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the given data.</P><P></P><P>Want to create a bar chart showing days as dimension and count of site id as a measure. Month and year are given in selection.</P><P>My problem is to show, count of site ID based on site live date and site close date.</P><P></P><P>Suppose, I have 1000 ATM initially on 1st Nov 2016. On 2nd Nov 2016, 200 ATM are added, whereas 100 ATM are closed so it should the show 1000+200-100=1100 site ID. Similarly for all days of Nov month.</P><P></P><P>I also have the records Showing close date year 2099 which are not closed yet. So, they must be added to all the records.</P><P></P><P>Thnaks&amp; Regards,</P><P>Jyoti</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401773#M797076 Anonymous 2020-11-25T16:16:04Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401774#M797077 <HTML><HEAD></HEAD><BODY><P>Would you be able to share the above data in an Excel format?</P></BODY></HTML> Thu, 14 Dec 2017 13:49:39 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401774#M797077 sunny_talwar 2017-12-14T13:49:39Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401775#M797078 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>I have attached the data file. Kindly, look after it.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 14 Dec 2017 15:02:40 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401775#M797078 Anonymous 2017-12-14T15:02:40Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401776#M797079 <HTML><HEAD></HEAD><BODY><P>Does this looks like what you are looking to get?</P><P></P><P><IMG __jive_id="187026" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187026_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 14 Dec 2017 16:23:54 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401776#M797079 sunny_talwar 2017-12-14T16:23:54Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401777#M797080 <HTML><HEAD></HEAD><BODY><P>I want day wise data. Total count value should reflect all added records and substract deleted records on that particular day.</P></BODY></HTML> Thu, 14 Dec 2017 18:31:31 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401777#M797080 Anonymous 2017-12-14T18:31:31Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401778#M797081 <HTML><HEAD></HEAD><BODY><P>Just change the dimension to be Date</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187038_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 14 Dec 2017 18:48:32 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401778#M797081 sunny_talwar 2017-12-14T18:48:32Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401779#M797082 <HTML><HEAD></HEAD><BODY><P>I not understanding how interval match will work here.</P><P>Could you please explain. In addition to this, how the records are increasing and decreasing in count.</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187116_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 15 Dec 2017 10:38:53 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401779#M797082 Anonymous 2017-12-15T10:38:53Z Re: Showing cumulative sum while adding and deleting records https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401780#M797083 <HTML><HEAD></HEAD><BODY><P>Interval match looks for the start and end date and based on this information it determines if a particular ATM_ID is open or closed.... for example</P><P></P><P>ATM_ID 10 had a date range of 01/01/2017 to 31/03/2017... so based on this information, all dates between 01/01/2017 and 31/03/2017, the ATM_ID will be counted, rest of the dates, it will not be counted.</P><P></P><P>Does this make sense? Should answer both the questions for you....</P></BODY></HTML> Fri, 15 Dec 2017 10:42:19 GMT https://community.qlik.com/t5/QlikView/Showing-cumulative-sum-while-adding-and-deleting-records/m-p/1401780#M797083 sunny_talwar 2017-12-15T10:42:19Z