topic Re: cumulative in QlikView https://community.qlik.com/t5/QlikView/cumulative/m-p/1054543#M353595 <HTML><HEAD></HEAD><BODY><P>We can play a guessing game and blindly make guesses until somebody guesses correctly. But this can be resolved a lot faster if you can post a small qlikview document that contains some relevant data. That way we can see what values your fields contain and what your variables contain.</P></BODY></HTML> Mon, 02 May 2016 15:48:22 GMT Gysbert_Wassenaar 2016-05-02T15:48:22Z cumulative https://community.qlik.com/t5/QlikView/cumulative/m-p/1054542#M353594 <HTML><HEAD></HEAD><BODY><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Hello,</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">I need your help please, I want to calculate the cumulative amount</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">For example if I select filters in April of the year selected (or selected years), the amount displayed must be the sum of (January + February + March + April) for the year or the selected years .</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">I tested</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">= Rangesum (Above (Sum (Sales), 0, [number months])) unsuccessfully</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">With either set analysis</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">sum ({&lt;= Years, Months =, DateNum = { "$ (= '&gt; =' &amp; vMinDateCalSMART &amp; '&lt;=' &amp; vMaxDateCalSMART)"}&gt;} ACTUALERP_S) / Weight</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Thanks for your help</SPAN></P></BODY></HTML> Mon, 02 May 2016 08:59:25 GMT https://community.qlik.com/t5/QlikView/cumulative/m-p/1054542#M353594 MauriceLudo 2016-05-02T08:59:25Z Re: cumulative https://community.qlik.com/t5/QlikView/cumulative/m-p/1054543#M353595 <HTML><HEAD></HEAD><BODY><P>We can play a guessing game and blindly make guesses until somebody guesses correctly. But this can be resolved a lot faster if you can post a small qlikview document that contains some relevant data. That way we can see what values your fields contain and what your variables contain.</P></BODY></HTML> Mon, 02 May 2016 15:48:22 GMT https://community.qlik.com/t5/QlikView/cumulative/m-p/1054543#M353595 Gysbert_Wassenaar 2016-05-02T15:48:22Z