https://community.qlik.com/t5/App-Development/Running-Balance-Line-Chart/m-p/1606338#M44905 <P>I made the following line chart showing our daily LG. But I would like the line to increase with each days LG.</P><P>I add a Screenshot with the Line Chart and Dimension. The Chart is filtered for a Specific Month.</P><P>Here is my Formula:</P><P><STRONG>RangeSum( Above( Sum(if(TTYPE = 'Lo' and TGROUPTYPE = 'Lo', CAPITAL)),0,RowNo() ) )</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16077i199DACA5ED305CA4/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Fri, 26 Jul 2019 06:19:25 GMT BouwerVa 2019-07-26T06:19:25Z https://community.qlik.com/t5/App-Development/Running-Balance-Line-Chart/m-p/1606338#M44905 <P>I made the following line chart showing our daily LG. But I would like the line to increase with each days LG.</P><P>I add a Screenshot with the Line Chart and Dimension. The Chart is filtered for a Specific Month.</P><P>Here is my Formula:</P><P><STRONG>RangeSum( Above( Sum(if(TTYPE = 'Lo' and TGROUPTYPE = 'Lo', CAPITAL)),0,RowNo() ) )</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16077i199DACA5ED305CA4/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Fri, 26 Jul 2019 06:19:25 GMT https://community.qlik.com/t5/App-Development/Running-Balance-Line-Chart/m-p/1606338#M44905 BouwerVa 2019-07-26T06:19:25Z https://community.qlik.com/t5/App-Development/Running-Balance-Line-Chart/m-p/1606352#M44907 <P>It works perfectly within a table but as soon as I put it in a graph it doesn't work.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16078i946B49C5086489C1/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Fri, 26 Jul 2019 06:47:54 GMT https://community.qlik.com/t5/App-Development/Running-Balance-Line-Chart/m-p/1606352#M44907 BouwerVa 2019-07-26T06:47:54Z