topic Re: Need a running sum in QlikView https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420872#M699563 <HTML><HEAD></HEAD><BODY><P>Thanks very much. This works !!</P></BODY></HTML> Mon, 10 Dec 2012 12:57:36 GMT 2012-12-10T12:57:36Z Need a running sum https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420870#M699561 <HTML><HEAD></HEAD><BODY><P>From 2 tabels (Bank account and Forecast)&nbsp; I have the following information. </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </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>Date (T1 and T2)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Current Account Balance (T1)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Forecast (T2)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Running Sum</STRONG></SPAN></TH></TR><TR><TD>01/01</TD><TD>100</TD><TD>50</TD><TD>100</TD></TR><TR><TD>02/01</TD><TD>110</TD><TD>90</TD><TD>110</TD></TR><TR><TD>03/01</TD><TD>0</TD><TD>0</TD><TD><SPAN style="color: #ff0000;">110</SPAN></TD></TR><TR><TD>04/01</TD><TD>0</TD><TD>50</TD><TD><SPAN style="color: #ff0000;">160</SPAN></TD></TR><TR><TD>05/01</TD><TD>0</TD><TD>- 40</TD><TD><SPAN style="color: #ff0000;">120</SPAN></TD></TR><TR><TD>06/01</TD><TD>0</TD><TD>0</TD><TD><SPAN style="color: #ff0000;">120</SPAN></TD></TR><TR><TD>07/01</TD><TD>0</TD><TD>80</TD><TD><SPAN style="color: #ff0000;">200</SPAN></TD></TR></TBODY></TABLE><P></P><P>I need a running sum (03/01) from the moment the last Current Balance is know.&nbsp; How can this be calculated?</P><P></P><P>Thanks</P><P>John</P></BODY></HTML> Mon, 10 Dec 2012 10:44:51 GMT https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420870#M699561 2012-12-10T10:44:51Z Re: Need a running sum https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420871#M699562 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please find the attached file hope it helps you requirement.</P></BODY></HTML> Mon, 10 Dec 2012 12:04:57 GMT https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420871#M699562 sreenivas 2012-12-10T12:04:57Z Re: Need a running sum https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420872#M699563 <HTML><HEAD></HEAD><BODY><P>Thanks very much. This works !!</P></BODY></HTML> Mon, 10 Dec 2012 12:57:36 GMT https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420872#M699563 2012-12-10T12:57:36Z Re: Need a running sum https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420873#M699564 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>This workds. Thanks very much for your help. </P></BODY></HTML> Mon, 10 Dec 2012 13:02:10 GMT https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420873#M699564 2012-12-10T13:02:10Z Re: Need a running sum https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420874#M699565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this sample file</P><P></P><P>Best of luck</P></BODY></HTML> Mon, 10 Dec 2012 13:19:45 GMT https://community.qlik.com/t5/QlikView/Need-a-running-sum/m-p/420874#M699565 2012-12-10T13:19:45Z