topic Re: Month not filtered correctly in QlikView

Month not filtered correctly

Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 13 May 2016 07:30:39 GMT

Hi,

Look at master calendar and canonical calendar

Regards

MK_QSL — Fri, 13 May 2016 08:13:38 GMT

Use this...

Fri, 13 May 2016 09:40:13 GMT

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.

Fri, 13 May 2016 09:49:16 GMT

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,

Fri, 13 May 2016 10:39:11 GMT

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

Sat, 14 May 2016 07:49:37 GMT

Dear QV Experts,

Please find the solution.

Thanks