topic Opening Balance in QlikView https://community.qlik.com/t5/QlikView/Opening-Balance/m-p/686747#M1067621 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>Can someone help to explain how to get the Opening Balance in Table 2, it should be the same answer as Table 1?.</P><P></P><P>Thank You</P><P>Tracy</P></BODY></HTML> Mon, 01 Sep 2014 22:58:17 GMT tracycrown 2014-09-01T22:58:17Z Opening Balance https://community.qlik.com/t5/QlikView/Opening-Balance/m-p/686747#M1067621 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>Can someone help to explain how to get the Opening Balance in Table 2, it should be the same answer as Table 1?.</P><P></P><P>Thank You</P><P>Tracy</P></BODY></HTML> Mon, 01 Sep 2014 22:58:17 GMT https://community.qlik.com/t5/QlikView/Opening-Balance/m-p/686747#M1067621 tracycrown 2014-09-01T22:58:17Z Re: Opening Balance https://community.qlik.com/t5/QlikView/Opening-Balance/m-p/686748#M1067622 <HTML><HEAD></HEAD><BODY><P>try with</P><P>=Before(sum(Data))</P></BODY></HTML> Mon, 01 Sep 2014 23:25:53 GMT https://community.qlik.com/t5/QlikView/Opening-Balance/m-p/686748#M1067622 maxgro 2014-09-01T23:25:53Z