Due vs Paid amount - Date Issue

Mon, 29 Oct 2012 07:45:19 GMT

Hi ,

I am facing issue while plotting the following data.

sample Data model is attached along with qvw.

I have a table consisting 4 columns- AccountId,DueAmount,PaidAmount,DueDate,PaidDate.

I want to plot..due amount and paid amount against each of these dates either due date or paid date.

Problem:

I want to show for a DueDate how much DueAmount has been collected till date. example: say PaidAmount till date for a due date of april

Issue:

When I plot duedate vs dueamount and paidamount...I get dueamount correct but incorrect paidamount ( actually it shows paidamount for respective due dates in the respective month, which is correct, however, I want it to show paid amount till date in that respective month)

When I plot paidddate vs dueamount and paidamount...I get incorrect dueamount but correct paidamount...explanation same as above.

Im am attaching a sample application I have plotted one pivot table with duedate as dimension and plotted another chart with paid date as dimension(currently April,May and Jun is used) .

Any solutions for such a situation?

Thanks and regards

s_tushar

topic Due vs Paid amount - Date Issue in QlikView

Due vs Paid amount - Date Issue