topic Accumulative columns in QlikView https://community.qlik.com/t5/QlikView/Accumulative-columns/m-p/283016#M1186332 <HTML><HEAD></HEAD><BODY><P> You could probably make use of a chart inter record function, try e.g.</P><P></P><P>= opening_balance + rangesum(above(daily_total,0,rowno()))</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 22 Sep 2011 14:36:43 GMT swuehl 2011-09-22T14:36:43Z Accumulative columns https://community.qlik.com/t5/QlikView/Accumulative-columns/m-p/283015#M1186331 <HTML><HEAD></HEAD><BODY><P>I have 2 tables, 1 for daily transactions and 1 for opening balances. I require a field that accumulates the opening balance to the daily totals. In this way i will get the daily balance of the account. </P><P>eg if the opening balance is 1000</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>eff_date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>daily total</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>accumulative total</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH></TR><TR><TD>1/09/2011</TD><TD>100</TD><TD>1100</TD><TD></TD></TR><TR><TD>2/09/2011</TD><TD>300</TD><TD>1400</TD><TD></TD></TR><TR><TD>3/09/2011</TD><TD>200</TD><TD>1600</TD><TD></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 22 Sep 2011 14:31:08 GMT https://community.qlik.com/t5/QlikView/Accumulative-columns/m-p/283015#M1186331 2011-09-22T14:31:08Z Accumulative columns https://community.qlik.com/t5/QlikView/Accumulative-columns/m-p/283016#M1186332 <HTML><HEAD></HEAD><BODY><P> You could probably make use of a chart inter record function, try e.g.</P><P></P><P>= opening_balance + rangesum(above(daily_total,0,rowno()))</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 22 Sep 2011 14:36:43 GMT https://community.qlik.com/t5/QlikView/Accumulative-columns/m-p/283016#M1186332 swuehl 2011-09-22T14:36:43Z