topic Re: DATA MATCH in QlikView

DATA MATCH

upaliwije — Sat, 20 Feb 2016 06:02:35 GMT

Hi Friends

I have attached my QV document where I have Policy Data and Claim Data. I want match to these data and create a single table with following conditoins

1.How many claims(Count of Claim_no) and what is the paid amount for such claims against each Policy No

2. Date of Loss should between policy period of particular policy

3.Paid date should also be included.

Pls help me to write the script

Re: DATA MATCH

Sat, 20 Feb 2016 06:41:05 GMT

this way you looking for

Re: DATA MATCH

upaliwije — Sat, 20 Feb 2016 08:23:52 GMT

Can someone pls help me to build the script as per my requirement

Re: DATA MATCH

Gysbert_Wassenaar — Sat, 20 Feb 2016 12:32:02 GMT

Try this:

CLM_Data:

LOAD POLICY_NO,

PERIOD_FROM as PERIOD_FROM_CLM,

PERIOD_TO as PERIOD_TO_CLM,

CLAIM_NO,

PAID_AMOUNT,

LOSS_DATE,

PAID_DATE

FROM

comm206360_CLM_DATA.xls

(biff, embedded labels, table is Sheet1$);

IntervalMatch:

INTERVALMATCH(LOSS_DATE,POLICY_NO)

LOAD

PERIOD_FROM,

PERIOD_TO,

POLICY_NO

FROM

comm206360_PRE_DATA.xls

(biff, embedded labels, table is Sheet1$);

Re: DATA MATCH

upaliwije — Sat, 20 Feb 2016 14:12:24 GMT

Pls upload the sample file for me to see it

Re: DATA MATCH

upaliwije — Sat, 20 Feb 2016 14:13:38 GMT

Thanks

But here a synthetic table is created how Can I avoid IT. IF you can pls attach the modified file

Re: DATA MATCH

Gysbert_Wassenaar — Sat, 20 Feb 2016 14:31:28 GMT

That synthetic key is supposed to be there. There's no need to remove it.

Re: DATA MATCH

sunny_talwar — Sat, 20 Feb 2016 14:40:45 GMT

Synthetic key in this case isn't a bad thing. Read the second last paragraph from HIC's blog post: IntervalMatch