Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

INTERVAL MATCH

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

4 Replies
sunny_talwar

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;

upaliwije
Creator II
Creator II
Author

Thanks Sunny

Still the result is same No change

bohravanraj
Partner - Creator II
Partner - Creator II

Please Refer attach QVW

upaliwije
Creator II
Creator II
Author

Thanks

Premium is not shown there