Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dowload testMultipleDatesOneCalendar from this thread.qvw http://community.qlik.com/message/248204#248204
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
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