how to calculate oustanding - Qlik Community

vikasmahajan · ‎2013-04-22

dear all

Please find attachment of qvw file in this I want to calculate document amt and ref adjusted document amt and balance amt as oustanding

I want to disply os amt for doc no col/12-13-vc/0993 amt = -8600 and total adjusted amt as 8587.66

and balance o/s 12.34 for document balance like this for each doc o/s to find

How to achive this Please help me to arrive the same

Henric Sir, Can I use apply map function for achiving the same ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

hic · ‎2013-04-23

First, if you want only one row per document in the table, you should not use ADJDOCNO as dimension. The document number alone as dimension is enough.,

Secondly, if you want the balance to be -12.34 for this document, you should add the two amounts instead of subtracting one from the other, i.e. use =sum(DOC_AMT)+SUM(ADJAMT) as expression instead of what you have now.

HIC

vikasmahajan · ‎2013-04-24

Dear Sir

I want to disply document amt as well as ajusted documents in one view only please guide to achive the same

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.