topic Help with Setanalysis with accumlation in QlikView https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423748#M801034 <HTML><HEAD></HEAD><BODY><P>In the app we have data for funds balance from year 1997 to future months. But when I display in the chart I wanted to show I wanted to use display month year field instead of year month field. </P><P></P><P>Display Month year field is populated from Apr 2016 onward to future months ( 2018). But our final expression should take the previous months balance and then accumulate from there. Even though users filter the data on display fiscal year should always start the values from all previous months total and then accumulate. </P><P></P><P></P><P>Let me know if you have any other questions</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Help with Setanalysis with accumlation https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423748#M801034 <HTML><HEAD></HEAD><BODY><P>In the app we have data for funds balance from year 1997 to future months. But when I display in the chart I wanted to show I wanted to use display month year field instead of year month field. </P><P></P><P>Display Month year field is populated from Apr 2016 onward to future months ( 2018). But our final expression should take the previous months balance and then accumulate from there. Even though users filter the data on display fiscal year should always start the values from all previous months total and then accumulate. </P><P></P><P></P><P>Let me know if you have any other questions</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423748#M801034 Anonymous 2020-11-25T16:16:04Z Re: Help with Setanalysis with accumlation https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423749#M801035 <HTML><HEAD></HEAD><BODY><P>May be this, assuming you have QV12</P><P></P><P><STRONG>Aggr(RangeSum(Above(Sum({&lt;DisplayMonthYear, DisplayYearMonth&gt;}[Funds Balance final]), 0, RowNo())), (YearMonth, (NUMERIC)))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185651_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 04 Dec 2017 19:18:57 GMT https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423749#M801035 sunny_talwar 2017-12-04T19:18:57Z Re: Help with Setanalysis with accumlation https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423750#M801036 <HTML><HEAD></HEAD><BODY><P>thank you rey that is what i wanted.</P></BODY></HTML> Mon, 04 Dec 2017 19:46:21 GMT https://community.qlik.com/t5/QlikView/Help-with-Setanalysis-with-accumlation/m-p/1423750#M801036 Anonymous 2017-12-04T19:46:21Z