Hello All,
it has been quite challenging for as the logic is been occurred differently.
But i have put 4 attachments one with the calculated raw data(Original Reference Doc), script, Verified Logic File, No Clearance_Document_Number
Verified Logic File : This file has the logic marked in yellow and red which needs to be implemented in QLikview
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
And to get the Balance Column every value of the Payment column should be multiplied with Sum of payment marked in red.
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
Please Help in achieving this.
Regards
