topic Re: how to create result with sum above cumulative value of same column? in QlikView https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376585#M615795 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where you are trying to do this? or may be share your Excel file with the raw data and the expected output you want to see</P></BODY></HTML> Thu, 10 Aug 2017 11:52:15 GMT sunny_talwar 2017-08-10T11:52:15Z how to create result with sum above cumulative value of same column? https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376584#M615794 <HTML><HEAD></HEAD><BODY><P>Hi guys, your help are appreciated!</P><P>I have date set attached and i want to create a new column which need to use above rows cumulative value of that same column, i am stuck doing it in neither script or expression, any help?</P><P></P><P><IMG alt="rolling calculation in same column.png" class="jive-image image-1" src="/legacyfs/online/173024_rolling calculation in same column.png" style="height: 103px; width: 620px;" /></P></BODY></HTML> Thu, 10 Aug 2017 07:22:39 GMT https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376584#M615794 huangchao 2017-08-10T07:22:39Z Re: how to create result with sum above cumulative value of same column? https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376585#M615795 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where you are trying to do this? or may be share your Excel file with the raw data and the expected output you want to see</P></BODY></HTML> Thu, 10 Aug 2017 11:52:15 GMT https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376585#M615795 sunny_talwar 2017-08-10T11:52:15Z Re: how to create result with sum above cumulative value of same column? https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376586#M615796 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>KEY is main dimension</P><P>Month is time dimension</P><P></P><P>logic is:</P><P>1.for each KEY, if Month is past month then wanted result is 0</P><P>2.<SPAN style="font-size: 13.3333px;">for each KEY, </SPAN>if Month is equal or larger than current month, then depending on Balance value (&lt;0 or &gt;=0) to use different calculation way (details in attached file)</P><P></P><P>most hard part to me is using cumulative value of above rows as a input for next row, in excel it's easy.</P><P></P><P>regards/HC</P></BODY></HTML> Thu, 10 Aug 2017 13:01:46 GMT https://community.qlik.com/t5/QlikView/how-to-create-result-with-sum-above-cumulative-value-of-same/m-p/1376586#M615796 huangchao 2017-08-10T13:01:46Z