topic Re: Cumulative Sum with condition in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114482#M762311 <HTML><HEAD></HEAD><BODY><P>Thank you very much, it works!</P></BODY></HTML> Wed, 08 Aug 2018 10:50:21 GMT Anonymous 2018-08-08T10:50:21Z Cumulative Sum with condition https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114480#M762309 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I'm not able to figure out how to solve this issue: I have a pivot table with some dimensions an expression that is the sum of a quantity (Forecast) and I'd like to have a new expression that is the cumulative sum of the "Forecast" but only for the rows with the same month.</P><P>Attached you will find an example on what I'd like to have (i.e. line 14 column G= line 14 column F+ line 2 column F)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114480#M762309 Anonymous 2020-11-25T16:16:04Z Re: Cumulative Sum with condition https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114481#M762310 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Aggr(RangeSum(Above(Sum(Forecast), 0, RowNo())), Name, ItemId, Month, (Year, (NUMERIC)))</STRONG></P></BODY></HTML> Tue, 07 Aug 2018 13:03:48 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114481#M762310 sunny_talwar 2018-08-07T13:03:48Z Re: Cumulative Sum with condition https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114482#M762311 <HTML><HEAD></HEAD><BODY><P>Thank you very much, it works!</P></BODY></HTML> Wed, 08 Aug 2018 10:50:21 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-with-condition/m-p/114482#M762311 Anonymous 2018-08-08T10:50:21Z