topic Running Balance in QlikView https://community.qlik.com/t5/QlikView/Running-Balance/m-p/31751#M5349 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Been working for days and can't seem to find the right way to do a running balance.</P><P></P><P>This is the output I'm trying to achieve:</P><P><SPAN lang="EN-US" style="font-family: 'Arial',sans-serif;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 0.05pt; width: 273px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid #88baea 1.0pt; border-bottom: none; background: #AED0F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P><STRONG style="color: black; font-size: 10.0pt;">Total</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #88BAEA 1.0pt; border-left: none; border-bottom: none; border-right: solid #88BAEA 1.0pt; background: #AED0F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P><STRONG style="color: black; font-size: 10.0pt;">Balance</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10852</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10852</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10851</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10850</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10848</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10845</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10840</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10835</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10825</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10815</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10805</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10795</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10775</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10755</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">25</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10730</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">25</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10705</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">50</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10655</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">60</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10595</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10590</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10582</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>I need to add an expression balance as shown above to the attached chart.</P><P></P><P>I tried RangeSum(Above(Total),0,RowNo()) but it's adding, not subtracting. </P><P></P><P>Thanks in advance.</P><P>-R</P></BODY></HTML> Thu, 01 Feb 2018 03:47:10 GMT rmangali 2018-02-01T03:47:10Z Running Balance https://community.qlik.com/t5/QlikView/Running-Balance/m-p/31751#M5349 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Been working for days and can't seem to find the right way to do a running balance.</P><P></P><P>This is the output I'm trying to achieve:</P><P><SPAN lang="EN-US" style="font-family: 'Arial',sans-serif;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 0.05pt; width: 273px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid #88baea 1.0pt; border-bottom: none; background: #AED0F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P><STRONG style="color: black; font-size: 10.0pt;">Total</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #88BAEA 1.0pt; border-left: none; border-bottom: none; border-right: solid #88BAEA 1.0pt; background: #AED0F1; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P><STRONG style="color: black; font-size: 10.0pt;">Balance</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10852</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10852</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10851</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10850</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10848</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10845</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10840</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10835</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10825</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10815</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10805</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10795</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10775</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10755</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">25</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10730</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">25</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10705</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">50</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10655</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">60</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10595</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10590</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="105"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="168"><P align="right" style="text-align: right;"><SPAN style="font-size: 10.0pt; color: black;">10582</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>I need to add an expression balance as shown above to the attached chart.</P><P></P><P>I tried RangeSum(Above(Total),0,RowNo()) but it's adding, not subtracting. </P><P></P><P>Thanks in advance.</P><P>-R</P></BODY></HTML> Thu, 01 Feb 2018 03:47:10 GMT https://community.qlik.com/t5/QlikView/Running-Balance/m-p/31751#M5349 rmangali 2018-02-01T03:47:10Z