topic Expression? in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/471475#M176082 <HTML><HEAD></HEAD><BODY><P>Hi i am again with same,</P><P></P><P>I have opning balance for every month, it will carry forwarded to next month,</P><P></P><P>Suppose in the month Apr i have my opning as 5000(i.e March closing in previous year) </P><P></P><P>every month we have value,</P><P></P><P>Apr = 300, May=-100, June=200, July= 300, Aug=-100, Sep=100</P><P></P><P>My result should be like this, if i selected Apr .... Closing of previous month+ value of present mnth....</P><P>i.e&nbsp; 5000+300= 5300 i am getting this value</P><P></P><P>now for May 5300-100= 5200, like this June= 5200+200= 5400, July 5400+300= 5700, Aug=5700-100= 5600, Sep 5600+100= 5700 this also i am getting correct.</P><P></P><P>But my issue is , If i selected Apr, May , June ... I need Apr(opening)+June(Closing)= 5000+5400, it should change dynamically as per selections. I need it in expression.</P><P></P><P>Please help on this.</P></BODY></HTML> Wed, 30 Jan 2013 12:16:52 GMT khadeer 2013-01-30T12:16:52Z Expression? https://community.qlik.com/t5/QlikView/Expression/m-p/471475#M176082 <HTML><HEAD></HEAD><BODY><P>Hi i am again with same,</P><P></P><P>I have opning balance for every month, it will carry forwarded to next month,</P><P></P><P>Suppose in the month Apr i have my opning as 5000(i.e March closing in previous year) </P><P></P><P>every month we have value,</P><P></P><P>Apr = 300, May=-100, June=200, July= 300, Aug=-100, Sep=100</P><P></P><P>My result should be like this, if i selected Apr .... Closing of previous month+ value of present mnth....</P><P>i.e&nbsp; 5000+300= 5300 i am getting this value</P><P></P><P>now for May 5300-100= 5200, like this June= 5200+200= 5400, July 5400+300= 5700, Aug=5700-100= 5600, Sep 5600+100= 5700 this also i am getting correct.</P><P></P><P>But my issue is , If i selected Apr, May , June ... I need Apr(opening)+June(Closing)= 5000+5400, it should change dynamically as per selections. I need it in expression.</P><P></P><P>Please help on this.</P></BODY></HTML> Wed, 30 Jan 2013 12:16:52 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/471475#M176082 khadeer 2013-01-30T12:16:52Z