Know debt situacion along the time: simulation. I need Help

[#1]

Hi, my name is Julio. Mi problem is next:

i've this table

Invoice	Paid Date	Amount
INV-1	23/08/2012	$1000
INV-2	25/08/2012	$2000
INV-3	25/08/2012	$1500
INV-4	31/08/2012	$500
INV-5	NOT PAID YET	$3000

All the invoices was made at 01/08/2012. I've other table, with a master calendar.

I want design a graphic that It show, for each day in Agoust, hoy much it was the debt, like this:

Date	Debt	Explication
22/08/2012	$8000	All Invoices are not paid
23/08/2012	$7000	INV-1 is paid
25/08/2012	$3500	INV-1,INV-2,INV-3 are paid
01/09/2012	$3000	Only the INV-5 is unpaid

I need, in a graphic or in script, a table that, for each day in my calendar, have the sum of all invoices that aren't paid

Thank you very much

[chematos]

Dowload testMultipleDatesOneCalendar from this thread.qvw http://community.qlik.com/message/248204#248204

[#3]

Thank you Jose Mª. With the calendar i haven't problem. I don't know how I can join the calendar table and the sum of invoices where Paid date >= calendar.day and then obtain the table that I show

[chematos]

With set analysis you can compare dates or anything to get a set of data you need:

sum({<PaidDate={'>=$(=calendar.day)'}>} InvoicesAmount)

See that this is only an example, you need to adapt to your model, with the information you give I can´t do an exact expression for your problem.

Regards