topic Calculate previous sum without variable in QlikView https://community.qlik.com/t5/QlikView/Calculate-previous-sum-without-variable/m-p/787959#M1036607 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I want to achieve the same without the use of variable, what I am doing here is that I am displaying balance (sum of values before 1st of each month e.g. for Jan 2014 before balance = sum of all all values &lt; 1 Jan 2014). Closing is the sum of all column values and closing value (of Jan) will go in the 1st cell of Feb and so on.</P><P></P><P>Actually the 1st value is calculated through a variable and if I directly put the formula in the expression I don't get the desired result. Can you please explain how it can be done without variable.</P><P></P><P><IMG alt="one 1.png" class="image-1 jive-image" src="/legacyfs/online/75279_one 1.png" style="height: 146px; width: 620px;" /></P><P></P><P><IMG alt="2 two.png" class="jive-image image-2" src="/legacyfs/online/75280_2 two.png" style="height: 473px; width: 620px;" /></P><P></P><P></P><P></P><P>Regards,</P><P>Muhammad Raza</P></BODY></HTML> Wed, 14 Jan 2015 11:17:38 GMT muhammadraza 2015-01-14T11:17:38Z Calculate previous sum without variable https://community.qlik.com/t5/QlikView/Calculate-previous-sum-without-variable/m-p/787959#M1036607 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I want to achieve the same without the use of variable, what I am doing here is that I am displaying balance (sum of values before 1st of each month e.g. for Jan 2014 before balance = sum of all all values &lt; 1 Jan 2014). Closing is the sum of all column values and closing value (of Jan) will go in the 1st cell of Feb and so on.</P><P></P><P>Actually the 1st value is calculated through a variable and if I directly put the formula in the expression I don't get the desired result. Can you please explain how it can be done without variable.</P><P></P><P><IMG alt="one 1.png" class="image-1 jive-image" src="/legacyfs/online/75279_one 1.png" style="height: 146px; width: 620px;" /></P><P></P><P><IMG alt="2 two.png" class="jive-image image-2" src="/legacyfs/online/75280_2 two.png" style="height: 473px; width: 620px;" /></P><P></P><P></P><P></P><P>Regards,</P><P>Muhammad Raza</P></BODY></HTML> Wed, 14 Jan 2015 11:17:38 GMT https://community.qlik.com/t5/QlikView/Calculate-previous-sum-without-variable/m-p/787959#M1036607 muhammadraza 2015-01-14T11:17:38Z