https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629668#M595619 <P>Is this not working then?</P><LI-CODE lang="markup">=RangeSum(Above(Sum({&lt;Jahr = {$(#=only(Jahr)-1)}&gt;} [Umsatz.Verkauf (MW)]), 0, RowNo()))</LI-CODE><P>&nbsp;</P> Mon, 30 Sep 2019 15:59:05 GMT sunny_talwar 2019-09-30T15:59:05Z https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629655#M595616 <P>Hi tohether,</P><P>i had a problem with rangeSum.</P><P>I need the cumulated sum for the actual and the previous year.</P><P>For the actual year it works fine with:</P><P>=rangesum(above(sum([Umsatz.Verkauf (MW)]), 0, rowno()))</P><P>What i have to do for the previous year?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/20374i78D2408626C960C4/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P> Sat, 16 Nov 2024 02:21:00 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629655#M595616 alangho 2024-11-16T02:21:00Z https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629666#M595617 <P>What is your expression for the Umsatz 2017 column?</P> Mon, 30 Sep 2019 15:55:19 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629666#M595617 sunny_talwar 2019-09-30T15:55:19Z https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629667#M595618 <P><EM>sum({&lt;Jahr={$(#=only(Jahr)-1)}&gt;}[Umsatz.Verkauf (MW)])</EM></P> Mon, 30 Sep 2019 15:56:46 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629667#M595618 alangho 2019-09-30T15:56:46Z https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629668#M595619 <P>Is this not working then?</P><LI-CODE lang="markup">=RangeSum(Above(Sum({&lt;Jahr = {$(#=only(Jahr)-1)}&gt;} [Umsatz.Verkauf (MW)]), 0, RowNo()))</LI-CODE><P>&nbsp;</P> Mon, 30 Sep 2019 15:59:05 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629668#M595619 sunny_talwar 2019-09-30T15:59:05Z https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629670#M595621 <P><EM>Thanks it's working fine now.</EM></P> Mon, 30 Sep 2019 16:03:29 GMT https://community.qlik.com/t5/QlikView/RangeSum-with-date-in-the-past/m-p/1629670#M595621 alangho 2019-09-30T16:03:29Z