Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi, my name is Julio. Mi problem is next:
i've this table
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:
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:
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.