Summarising

Thu, 11 Apr 2013 13:34:51 GMT

I am relatively new to QlikView and am trying to find the amount outstanding for each client after all payments have been removed but am unable to figure out the correct formula.

I have it working on a line by line basis but not when grouping. For an individual line I am using Total - If(IsNull(Amount),0,Amount) but I need to get it working based on the Client where there could be three invoices for same client.

This table is working fine

Total - If(IsNull(Amount),0,Amount)

	Total	Amount	Balance
Client A	4,000.00	200.00	3,800.00
Client A	4,000.00	-	4,000.00
Client A	6,000.00	3,800.00	2,200.00
Client B	8,000.00	6,000.00	2,000.00

However I am unable to show it as below

	Total	Amount	Balance
Client A	14,000.00	4,000.00	10,000.00
Client B	8,000.00	6,000.00	2,000.00

Any help would be most appreciated.

topic Summarising in QlikView

Summarising