topic range sum question in QlikView https://community.qlik.com/t5/QlikView/range-sum-question/m-p/681420#M247035 <HTML><HEAD></HEAD><BODY><P>Dears</P><P>got a pivot table and 4 expressions grouped by period and release</P><P>what I want for the fourth expression is cummulative summation by release</P><P>i.e. </P><P>check the image; for release v3.1.27 on period 2 I want the value of 89 (21+68)</P><P>I wrote the following expression</P><P></P><P> <STRONG>$(vBackportedBugPostRelease) + $(vBackportedRegressionPostRelease)</STRONG></P><P>+ rangesum(above (total <STRONG>$(vBackportedBugPostRelease) + $(vBackportedRegressionPostRelease)</STRONG>,1&nbsp; , RowNo(TOTAL)))</P><P></P><P>but I'm getting the value of 101 (summing the remaining records that have 5,5,1, and 1 as values</P><P></P><P>Please advise</P></BODY></HTML> Mon, 01 Sep 2014 08:50:46 GMT ali_hijazi 2014-09-01T08:50:46Z range sum question https://community.qlik.com/t5/QlikView/range-sum-question/m-p/681420#M247035 <HTML><HEAD></HEAD><BODY><P>Dears</P><P>got a pivot table and 4 expressions grouped by period and release</P><P>what I want for the fourth expression is cummulative summation by release</P><P>i.e. </P><P>check the image; for release v3.1.27 on period 2 I want the value of 89 (21+68)</P><P>I wrote the following expression</P><P></P><P> <STRONG>$(vBackportedBugPostRelease) + $(vBackportedRegressionPostRelease)</STRONG></P><P>+ rangesum(above (total <STRONG>$(vBackportedBugPostRelease) + $(vBackportedRegressionPostRelease)</STRONG>,1&nbsp; , RowNo(TOTAL)))</P><P></P><P>but I'm getting the value of 101 (summing the remaining records that have 5,5,1, and 1 as values</P><P></P><P>Please advise</P></BODY></HTML> Mon, 01 Sep 2014 08:50:46 GMT https://community.qlik.com/t5/QlikView/range-sum-question/m-p/681420#M247035 ali_hijazi 2014-09-01T08:50:46Z