Month not filtered correctly

[#1]

Dear QV Experts,

Two charts in the dashboard. Earned Premium calculated in one chart & Claim amount calculated in another chart.

For Earned Premium Calculations, Start_Date & End_Date used.

For Claim Amount Calculation, Claim_Open_Date used.

In the Straight Tables below, the Earned Premium calculated for one month, when retrieved for 01/Jan/2013 to 31/Jan/2013.

But the Claim Amt not filtering the records & it is showing total claim amout.

Please find enclosed the qvw & spreadsheet. Please suggest me.

Thanks,

Sasi

[PrashantSangle]

Hi,

Look at master calendar and canonical calendar

Regards

[MK_QSL]

Use this...

Canonical Date

[#4]

Thanks Max, Manish.

Tried using the Canonical Date. The Earned Premium displays correctly.

But the claim amount some how not displaying the right values.

If the Date Range, 01/01/2013 to 01/31/2013, then the Claim amount should display 340

If retrieved between 02/01/2013 to 02/28/2013, then Claim Amount should display 400.

If retrieved between 01/01/2013 to 02/28/2013, then Claim Amount should display 740.

I think i am missing something in Expression. !

Can you please suggest me.

[#5]

When retrieved for Jan2013, The Certificate# 35875693, 36648194 of Claim Amount 300 & 40 respectively.

Along with this two rows, Certificate# 35422579 of Claim Amount 150 also included.

It displays 490 instead of 340.

This is because the Start_Date is before the FiscalStartDate.

How to avoid this? Please suggest me.

Thanks,

[#6 · Accepted solution]

Thanks all. It is resolved now. I introduced DateType column for both the tables & filtered based on the DateType column in the Expression.

[#7]

Dear QV Experts,

Please find the solution.

Thanks