topic Re: Running Total Problem in QlikView https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77314#M782823 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>1000-RangeSum(Above(TOTAL sum(Pallets),0,RowNo(TOTAL)))</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197280_Capture.JPG" style="height: 104px; width: 620px;" /></P></BODY></HTML> Fri, 23 Mar 2018 07:30:18 GMT tresB 2018-03-23T07:30:18Z Running Total Problem https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77313#M782822 <HTML><HEAD></HEAD><BODY><P>Good Day All,</P><P></P><P>I am having an issue with the below. Please see sample file.</P><P></P><P><STRONG>Problem statement:</STRONG></P><P></P><P>I have space in a warehouse for 1000 Pallets.&nbsp; I need to subtract the amount of Pallets ordered from this grand total.&nbsp; Meaning the end result should look like the below.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197274_Capture.PNG" style="height: auto;" /></P><P>I believe the solution can be accomplished using either the above or rangesum functions but I have not been successful in my attempts.</P><P></P><P>Could anyone please suggest any solutions.&nbsp; Whether it is frond-end or back end solutions.</P><P></P><P>Thanks in advance !</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77313#M782822 Anonymous 2020-11-25T16:16:04Z Re: Running Total Problem https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77314#M782823 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>1000-RangeSum(Above(TOTAL sum(Pallets),0,RowNo(TOTAL)))</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197280_Capture.JPG" style="height: 104px; width: 620px;" /></P></BODY></HTML> Fri, 23 Mar 2018 07:30:18 GMT https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77314#M782823 tresB 2018-03-23T07:30:18Z Re: Running Total Problem https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77315#M782824 <HTML><HEAD></HEAD><BODY><P>Thanks that worked.</P></BODY></HTML> Fri, 23 Mar 2018 07:34:27 GMT https://community.qlik.com/t5/QlikView/Running-Total-Problem/m-p/77315#M782824 Anonymous 2018-03-23T07:34:27Z