https://community.qlik.com/t5/QlikView/Running-Total/m-p/1619379#M735496 <P>Hi All,<BR />I have a table which has following fields(Columns)<BR />Date,Cdefect,CIDefects and Odefects.<BR />As shown in the below screenshot.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Data.PNG" style="width: 277px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/18329i1F90949A12ADFADB/image-size/large?v=v2&amp;px=999" role="button" title="Data.PNG" alt="Data.PNG" /></span><BR />Now i have to come up with a output table which should show me running total.<BR />where the Odefect will be added to Cdefect and the result will be Subracted from CIDefect and provides the output in Total<BR />this is how it repeats.<BR />Below is the screenshot of the Out put .</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="output.PNG" style="width: 270px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/18330i133C42CD2CF88C7A/image-size/large?v=v2&amp;px=999" role="button" title="output.PNG" alt="output.PNG" /></span></P><P>Can you please help me in achieving this</P><P>Thanks in Advance</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Running-Total/m-p/1619379#M735496 <P>Hi All,<BR />I have a table which has following fields(Columns)<BR />Date,Cdefect,CIDefects and Odefects.<BR />As shown in the below screenshot.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Data.PNG" style="width: 277px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/18329i1F90949A12ADFADB/image-size/large?v=v2&amp;px=999" role="button" title="Data.PNG" alt="Data.PNG" /></span><BR />Now i have to come up with a output table which should show me running total.<BR />where the Odefect will be added to Cdefect and the result will be Subracted from CIDefect and provides the output in Total<BR />this is how it repeats.<BR />Below is the screenshot of the Out put .</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="output.PNG" style="width: 270px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/18330i133C42CD2CF88C7A/image-size/large?v=v2&amp;px=999" role="button" title="output.PNG" alt="output.PNG" /></span></P><P>Can you please help me in achieving this</P><P>Thanks in Advance</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Running-Total/m-p/1619379#M735496 smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Running-Total/m-p/1619390#M735498 <P>There you go:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 617px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/18333iF59A5B8421E75AB0/image-dimensions/617x213?v=v2" width="617" height="213" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P><P>Build a new column (Total) at script level.</P><P>Refer attached qvw for the logic using peek() function.</P><P>Thanks and regards,</P><P>Arthur Fong</P> Tue, 03 Sep 2019 06:05:58 GMT https://community.qlik.com/t5/QlikView/Running-Total/m-p/1619390#M735498 Arthur_Fong 2019-09-03T06:05:58Z