topic Re: Accumulate sum Scripts in QlikView https://community.qlik.com/t5/QlikView/Accumulate-sum-Scripts/m-p/56846#M783755 <HTML><HEAD></HEAD><BODY><P>Solution attached</P></BODY></HTML> Tue, 06 Mar 2018 20:18:19 GMT shilpan 2018-03-06T20:18:19Z Accumulate sum Scripts https://community.qlik.com/t5/QlikView/Accumulate-sum-Scripts/m-p/56845#M783754 <HTML><HEAD></HEAD><BODY><P>Hi, I want to get the result that if there are accumulated flag_donated with 1,&nbsp; and I will create another column named tenure to add them.</P><P></P><P>For example, for 200708, there is a flag_donated with value 1, so the tenure value will be 1, and for 200709 with the flag value 1, the tenure value will be (1+1=2). And for 200711, there is a flag_donated with value 1, but the tenure will be 1, for 200712, the tenure will be 2. If the YearMonth is accumulated, the tenure will add 1.</P><P></P><P>How can I write the scripts on the data model?</P><P></P><P></P><P></P><P><IMG alt="Capture-1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195433_Capture-1.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Accumulate-sum-Scripts/m-p/56845#M783754 carol_wu 2020-11-25T16:16:04Z Re: Accumulate sum Scripts https://community.qlik.com/t5/QlikView/Accumulate-sum-Scripts/m-p/56846#M783755 <HTML><HEAD></HEAD><BODY><P>Solution attached</P></BODY></HTML> Tue, 06 Mar 2018 20:18:19 GMT https://community.qlik.com/t5/QlikView/Accumulate-sum-Scripts/m-p/56846#M783755 shilpan 2018-03-06T20:18:19Z