Need help on Reports based on two different dates

Tue, 22 Jan 2013 05:50:46 GMT

I Have a simple report to be generated ie

Due vs Collection for each month .

The fields are Due_date, Due_amount, Paid_date, Paid_amount in the table now i take due_date as a dimension and put expression as sum for due amount and paid amount .

The Due Amount sums up correct but the paid amount is incorrect for the given month .

I Have attached a sample application with Payments table and a master calender and the data for payments is for months april-2012

I want the logic to include total dues and total collection for a month ..

Can anyone help me out with this

Thanks in advance ,

s_tushar

Re: Need help on Reports based on two different dates

rwunderlich — Tue, 22 Jan 2013 08:18:45 GMT

Take a look at the tutorial "Using Common Date Dimensions and Shared Calendars " at http://robwunderlich.com/tutorials/.

The tutorial will show you how to aggregate two fact dates -- due_date & paid_date -- into a common month dimension.

-Rob

topic Re: Need help on Reports based on two different dates in QlikView

Need help on Reports based on two different dates

Re: Need help on Reports based on two different dates