topic Re: RangeSum not working properly in QlikView https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673644#M538446 <HTML><HEAD></HEAD><BODY><P>It's working, but not in the way we need...</P><P></P><P>we need to start with the accumulation from the oldest date to the youngest....</P><P><IMG alt="ScreenShot677.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/68417_ScreenShot677.jpg" /></P></BODY></HTML> Tue, 07 Oct 2014 14:06:03 GMT Markus_QV 2014-10-07T14:06:03Z RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673638#M538440 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem with the Rangesum-Function in QV11 and hope someone can help me.</P><P></P><P>I want to accumulate a column(column(5)), but after some rows have accurately been added , QV is starting in the next row by 0 again (check date 20140606).</P><P></P><P>(Pls. also see the qvw and the xlsx-file)</P><P></P><P>Can someone explain to me why that happened?</P><P><BR /><IMG __jive_id="68407" alt="Inv_Accum_Break_in_Couting.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/68407_Inv_Accum_Break_in_Couting.jpg" /></P><P>Best Regards</P><P>Markus</P></BODY></HTML> Tue, 07 Oct 2014 13:24:32 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673638#M538440 Markus_QV 2014-10-07T13:24:32Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673639#M538441 <HTML><HEAD></HEAD><BODY><P>Not able to open attached qvw</P></BODY></HTML> Tue, 07 Oct 2014 13:27:27 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673639#M538441 anbu1984 2014-10-07T13:27:27Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673640#M538442 <HTML><HEAD></HEAD><BODY><P>Pls. try the new version...</P></BODY></HTML> Tue, 07 Oct 2014 13:33:50 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673640#M538442 Markus_QV 2014-10-07T13:33:50Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673641#M538443 <HTML><HEAD></HEAD><BODY><P>Hi Markus,</P><P>try</P><P>RangeSum(Top(New#-Done#,1,RowNo()))</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 07 Oct 2014 13:45:24 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673641#M538443 antoniotiman 2014-10-07T13:45:24Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673642#M538444 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>Rangesum(New#-Done#,Above([Accumulated]))</P></BODY></HTML> Tue, 07 Oct 2014 13:50:27 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673642#M538444 anbu1984 2014-10-07T13:50:27Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673643#M538445 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P><STRONG>rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 07 Oct 2014 14:01:05 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673643#M538445 jerem1234 2014-10-07T14:01:05Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673644#M538446 <HTML><HEAD></HEAD><BODY><P>It's working, but not in the way we need...</P><P></P><P>we need to start with the accumulation from the oldest date to the youngest....</P><P><IMG alt="ScreenShot677.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/68417_ScreenShot677.jpg" /></P></BODY></HTML> Tue, 07 Oct 2014 14:06:03 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673644#M538446 Markus_QV 2014-10-07T14:06:03Z Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673645#M538447 <HTML><HEAD></HEAD><BODY><P>Perfect! That's working...</P><P></P><P>Thank you very much.....</P></BODY></HTML> Tue, 07 Oct 2014 14:11:53 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673645#M538447 Markus_QV 2014-10-07T14:11:53Z Re: Re: RangeSum not working properly https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673646#M538448 <HTML><HEAD></HEAD><BODY><P>Check this</P></BODY></HTML> Tue, 07 Oct 2014 14:16:33 GMT https://community.qlik.com/t5/QlikView/RangeSum-not-working-properly/m-p/673646#M538448 anbu1984 2014-10-07T14:16:33Z