topic In a chart, cumulative sum not persisting for a selected date range in QlikView https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415883#M560342 <HTML><HEAD></HEAD><BODY><H1><SPAN style="font-size: 10pt;">I need some help in calculating the cumulative sum which persists the value of the whole date range and display the same value for a selected range as well. </SPAN></H1><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Business case</SPAN></P><P><SPAN style="font-size: 10pt;">We need to measure “ongoing subscriptions” count which is sum of previous day's ongoing subscriptions and current date subscriptions.</SPAN></P><P><EM style="font-size: 10pt;">For day#1 Ongoing subscription is same as Subscription count.</EM></P><P></P><P>Attached: payvia_Qlikview_Support_MockUp.qvw</P><P></P><P>Screenshot#1 Cumulative sum for the whole date range</P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="40122" alt="#1.PNG" class="jive-image-thumbnail jive-image" height="236" src="https://community.qlik.com/legacyfs/online/40122_%231.PNG" style="height: 236px; width: 663.75px;" width="664" /></SPAN></P><P>Screenshot#2 Cumulative sum for the selected date range. Desired value is in highlighted color below which is calculated separately and added to the screenshot </P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="40123" alt="#2.PNG" class="jive-image-thumbnail jive-image" height="225" src="https://community.qlik.com/legacyfs/online/40123_%232.PNG" style="height: 225px; width: 636.7924528301887px;" width="637" /></SPAN></P><P>Screenshot#3: Cumulative sum for the entire date range for the selected filter</P><P><IMG __jive_id="40127" alt="#3.PNG" class="jive-image-thumbnail jive-image" height="215" src="https://community.qlik.com/legacyfs/online/40127_%233.PNG" style="height: 215px; width: 658.1632653061224px;" width="658" /></P><P></P><P>Screenshot#4: Cumulative sum of the selected date range and the filter. Desired result is highlighted and added in the below screenshot.</P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="40128" alt="#4.PNG" class="jive-image-thumbnail jive-image" height="226" src="https://community.qlik.com/legacyfs/online/40128_%234.PNG" style="height: 226px; width: 673.5099337748345px;" width="674" /></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I would greatly appreciate if someone can help me with this problem?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">FYI... I tried other approached like</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><UL><LI>Calculate the cumulative total at SQL level and roll it to the QVW but the issue is we never know what filters the user will be selecting. In the sample document I attached, I have only 3 filters but in my original copy, I have 7 different filters for the user to select</LI><LI>A single group by date would not work because, it will through off all the filters from the equation</LI></UL><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P></P><P>Thanks and I appreciate any help. </P></BODY></HTML> Wed, 01 May 2013 01:28:04 GMT 2013-05-01T01:28:04Z In a chart, cumulative sum not persisting for a selected date range https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415883#M560342 <HTML><HEAD></HEAD><BODY><H1><SPAN style="font-size: 10pt;">I need some help in calculating the cumulative sum which persists the value of the whole date range and display the same value for a selected range as well. </SPAN></H1><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Business case</SPAN></P><P><SPAN style="font-size: 10pt;">We need to measure “ongoing subscriptions” count which is sum of previous day's ongoing subscriptions and current date subscriptions.</SPAN></P><P><EM style="font-size: 10pt;">For day#1 Ongoing subscription is same as Subscription count.</EM></P><P></P><P>Attached: payvia_Qlikview_Support_MockUp.qvw</P><P></P><P>Screenshot#1 Cumulative sum for the whole date range</P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="40122" alt="#1.PNG" class="jive-image-thumbnail jive-image" height="236" src="https://community.qlik.com/legacyfs/online/40122_%231.PNG" style="height: 236px; width: 663.75px;" width="664" /></SPAN></P><P>Screenshot#2 Cumulative sum for the selected date range. Desired value is in highlighted color below which is calculated separately and added to the screenshot </P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="40123" alt="#2.PNG" class="jive-image-thumbnail jive-image" height="225" src="https://community.qlik.com/legacyfs/online/40123_%232.PNG" style="height: 225px; width: 636.7924528301887px;" width="637" /></SPAN></P><P>Screenshot#3: Cumulative sum for the entire date range for the selected filter</P><P><IMG __jive_id="40127" alt="#3.PNG" class="jive-image-thumbnail jive-image" height="215" src="https://community.qlik.com/legacyfs/online/40127_%233.PNG" style="height: 215px; width: 658.1632653061224px;" width="658" /></P><P></P><P>Screenshot#4: Cumulative sum of the selected date range and the filter. Desired result is highlighted and added in the below screenshot.</P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="40128" alt="#4.PNG" class="jive-image-thumbnail jive-image" height="226" src="https://community.qlik.com/legacyfs/online/40128_%234.PNG" style="height: 226px; width: 673.5099337748345px;" width="674" /></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I would greatly appreciate if someone can help me with this problem?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">FYI... I tried other approached like</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><UL><LI>Calculate the cumulative total at SQL level and roll it to the QVW but the issue is we never know what filters the user will be selecting. In the sample document I attached, I have only 3 filters but in my original copy, I have 7 different filters for the user to select</LI><LI>A single group by date would not work because, it will through off all the filters from the equation</LI></UL><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P></P><P>Thanks and I appreciate any help. </P></BODY></HTML> Wed, 01 May 2013 01:28:04 GMT https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415883#M560342 2013-05-01T01:28:04Z Re: In a chart, cumulative sum not persisting for a selected date range https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415884#M560343 <HTML><HEAD></HEAD><BODY><P>Has anyone gave a shot at this? </P></BODY></HTML> Fri, 24 May 2013 22:02:52 GMT https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415884#M560343 2013-05-24T22:02:52Z Re: In a chart, cumulative sum not persisting for a selected date range https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415885#M560344 <HTML><HEAD></HEAD><BODY><P>Try an AsOf table. See <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252">here</A> for an explanation of that concept and attached example.</P></BODY></HTML> Sat, 25 May 2013 06:16:05 GMT https://community.qlik.com/t5/QlikView/In-a-chart-cumulative-sum-not-persisting-for-a-selected-date/m-p/415885#M560344 Gysbert_Wassenaar 2013-05-25T06:16:05Z