Currently i am facing a issue in a Ageing Report generation where after extracting Data from Database there are some adjustment which is need to be done. Thsi Adjustment is when data is extracted from database there are some credit entry is wrongly being entered into credit column & vice-versa. this wrong entry is identified such as if there is any negative value in debit column then it is moved to credit and if there is any positive value in credit column then it is being moved to debit. but the problem is that this is not done at the transactional level but, it is done only after customer-wise ageing report is generated. so how this is possible in qlikview when the Ageing bucket are being made dynamically.
For example:
Following is the is the report generated in Qlikview but here i m facing problem in doing the adjustment where Negative value from debit row should have to move to credit & Vice-versa.
