topic INTERVAL MATCH in QlikView

INTERVAL MATCH

upaliwije — Fri, 26 Feb 2016 07:45:00 GMT

Hi,

I have created a QV document with claim and premium data where I want to match Loss date of a claim between period from and period to of a policy. But I do not get desired results .

All claim are matched disregarding policy period

Premium is show against each record where It should be shown in a separate row.

Kindly have a look at my QV document and advise

Re: INTERVAL MATCH

sunny_talwar — Fri, 26 Feb 2016 07:48:14 GMT

Can you see what happens when you make this change:

CLM_Data:

First 200

LOAD POLICY_NO,

// date(PERIOD_FROM,'DD-MMM-YYYY')AS PERIOD_FROM,

//date( PERIOD_TO,'DD-MMM-YYYY')AS PERIOD_TO,

CLAIM_NO,

CRE_PAID_AMOUNT AS PAID_AMOUNT,

Date(Floor( LOSS_DATE),'DD-MMM-YYYY')AS LOSS_DATE,

PAID_DATE,

RISK

FROM

PRE_CLM.QVD

(qvd)

WHERE BCOD='NI00'

;

PRE_DATA:

FIRST 200

LOAD

PERIOD_FROM,

PERIOD_TO,

POLICY_NO,

CLA_CODE,

PRD_CODE,

BCOD,

//REN,

PREMIUM

FROM

SORTED_POLICIES.QVD

(qvd)

WHERE BCOD='NI00';

IntervalMatch:

INTERVALMATCH(LOSS_DATE,POLICY_NO)

LOAD PERIOD_FROM,

PERIOD_TO,

POLICY_NO

RESIDENT PRE_DATA;

Re: INTERVAL MATCH

upaliwije — Fri, 26 Feb 2016 09:08:29 GMT

Thanks Sunny

Still the result is same No change

Re: INTERVAL MATCH

bohravanraj — Fri, 26 Feb 2016 09:51:12 GMT

Please Refer attach QVW

Re: INTERVAL MATCH

upaliwije — Fri, 26 Feb 2016 10:49:44 GMT

Thanks

Premium is not shown there