https://community.qlik.com/t5/QlikView/Accumulation-with-expression/m-p/1682306#M727152 <P>Hi im kinda lost here,</P><P>I would like to create a expression that accumulate like the attached table.</P><P>Rangesum(above(Diff, ), sum(diff)))</P><P>&nbsp;</P><TABLE width="567px"><TBODY><TR><TD width="78.1333px">Week</TD><TD width="105.183px">Budget</TD><TD width="123.217px">Sales</TD><TD width="123.217px">Diff</TD><TD width="136.25px">Ack</TD></TR><TR><TD width="78.1333px">2020-01</TD><TD width="105.183px">901 143</TD><TD width="123.217px">355 096</TD><TD width="123.217px">-546 047</TD><TD width="136.25px">-546 047</TD></TR><TR><TD width="78.1333px">2020-02</TD><TD width="105.183px">1 802 286</TD><TD width="123.217px">2 835 114</TD><TD width="123.217px">1 032 829</TD><TD width="136.25px">486 782</TD></TR><TR><TD width="78.1333px">2020-03</TD><TD width="105.183px">2 252 857</TD><TD width="123.217px">2 538 308</TD><TD width="123.217px">285 451</TD><TD width="136.25px">772 233</TD></TR><TR><TD width="78.1333px">2020-04</TD><TD width="105.183px">2 252 857</TD><TD width="123.217px">1 347 297</TD><TD width="123.217px">-905 560</TD><TD width="136.25px">-133 328</TD></TR><TR><TD width="78.1333px">2020-05</TD><TD width="105.183px">2 252 857</TD><TD width="123.217px">1 840 274</TD><TD width="123.217px">-412 583</TD><TD width="136.25px">-545 910</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT harjedalskok 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Accumulation-with-expression/m-p/1682306#M727152 <P>Hi im kinda lost here,</P><P>I would like to create a expression that accumulate like the attached table.</P><P>Rangesum(above(Diff, ), sum(diff)))</P><P>&nbsp;</P><TABLE width="567px"><TBODY><TR><TD width="78.1333px">Week</TD><TD width="105.183px">Budget</TD><TD width="123.217px">Sales</TD><TD width="123.217px">Diff</TD><TD width="136.25px">Ack</TD></TR><TR><TD width="78.1333px">2020-01</TD><TD width="105.183px">901 143</TD><TD width="123.217px">355 096</TD><TD width="123.217px">-546 047</TD><TD width="136.25px">-546 047</TD></TR><TR><TD width="78.1333px">2020-02</TD><TD width="105.183px">1 802 286</TD><TD width="123.217px">2 835 114</TD><TD width="123.217px">1 032 829</TD><TD width="136.25px">486 782</TD></TR><TR><TD width="78.1333px">2020-03</TD><TD width="105.183px">2 252 857</TD><TD width="123.217px">2 538 308</TD><TD width="123.217px">285 451</TD><TD width="136.25px">772 233</TD></TR><TR><TD width="78.1333px">2020-04</TD><TD width="105.183px">2 252 857</TD><TD width="123.217px">1 347 297</TD><TD width="123.217px">-905 560</TD><TD width="136.25px">-133 328</TD></TR><TR><TD width="78.1333px">2020-05</TD><TD width="105.183px">2 252 857</TD><TD width="123.217px">1 840 274</TD><TD width="123.217px">-412 583</TD><TD width="136.25px">-545 910</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-expression/m-p/1682306#M727152 harjedalskok 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Accumulation-with-expression/m-p/1682308#M727153 <P>Hello!</P><P>Accumulate expression will be:</P><P>RangeSum(&nbsp;Above(&nbsp; Diff&nbsp; ,0&nbsp; ,RowNo()&nbsp;))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="max_value.jpg" style="width: 748px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29667i1D9F25EC64029DCC/image-size/large?v=v2&amp;px=999" role="button" title="max_value.jpg" alt="max_value.jpg" /></span></P> Fri, 06 Mar 2020 05:02:46 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-expression/m-p/1682308#M727153 Sergey_Shuklin 2020-03-06T05:02:46Z