Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

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

i've this table

InvoicePaid DateAmount
INV-123/08/2012$1000
INV-225/08/2012$2000
INV-325/08/2012$1500
INV-431/08/2012$500
INV-5NOT 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:

DateDebtExplication
22/08/2012$8000All Invoices are not paid
23/08/2012$7000INV-1 is paid
25/08/2012$3500INV-1,INV-2,INV-3 are paid
01/09/2012$3000Only 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

3 Replies
chematos
Valued Contributor II

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

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

Not applicable

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

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
Valued Contributor II

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

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

Community Browser