https://community.qlik.com/t5/QlikView/To-get-the-Balance/m-p/1522048#M749080 <P>Please anyone help i need to submit in next 2 Hours.. please assist</P><P>below attachment is the expected output.</P><P>&nbsp;</P> Tue, 18 Dec 2018 09:53:33 GMT tahreen371 2018-12-18T09:53:33Z https://community.qlik.com/t5/QlikView/To-get-the-Balance/m-p/1522027#M749079 <P>Hello All,</P><P>it has been quite challenging for as the logic is been occurred differently.</P><P>But i have put 4 attachments one with the calculated raw data(Original Reference Doc), script, Verified Logic File, No Clearance_Document_Number</P><P>Verified Logic File : This file has the logic marked in yellow and red which needs to be implemented in QLikview<BR />referring this file, Based on CLEARING_DOCUMENT_NUMBER Sum up the Doc.Amount and that total Doc.Amount should be divided with every value of Doc.Amount related to every Doc_number to achieve PAYMENT COLUMN</P><P>And to get the Balance Column every value of the Payment column should be multiplied with Sum of payment marked in red.</P><P>and the No Clearance_Document_Number File: this shows an example where we dont have clearance number for a Customer_Number which means the Payment is pending and balance should be shown</P><P><BR />Please Help in achieving this.</P><P>&nbsp;</P><P>Regards</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/To-get-the-Balance/m-p/1522027#M749079 tahreen371 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/To-get-the-Balance/m-p/1522048#M749080 <P>Please anyone help i need to submit in next 2 Hours.. please assist</P><P>below attachment is the expected output.</P><P>&nbsp;</P> Tue, 18 Dec 2018 09:53:33 GMT https://community.qlik.com/t5/QlikView/To-get-the-Balance/m-p/1522048#M749080 tahreen371 2018-12-18T09:53:33Z