topic Re: interval match in QlikView

interval match

Anonymous — Fri, 09 Aug 2013 03:59:30 GMT

id1:

LOAD * INLINE [

ID,CreatedDate

1,10-Jul-2013

2,5-Jul-2013

3,8-Jul-2013

];

id2:

LOAD * INLINE [

ID,StartDate,EndDate,Batchno

1,7-Jul-2013,7-Jul-2013,AOO11

1,8-Jul-2013,8-Jul-2013,B932A

1,9-Jul-2013,12-Jul-2013,S0o1g

];

IntervalMatch:

IntervalMatch (CreatedDate)

Load distinct StartDate as stdt, EndDate as enddt , Batchno as Batch_no resident id2;

I want to map createdate in id1 with startdate and enddate in id2 to retrive the bath no.

why it is not working?

Re: interval match

Anonymous — Fri, 09 Aug 2013 06:07:28 GMT

IntervalMatch:

IntervalMatch (CreatedDate)

Load distinct StartDate as stdt , EndDate as enddt resident id2;

I have modified the interval matchj clause but it should come S0o1g batch no.But it is showing all three here

Regards

Re: interval match

hic — Fri, 09 Aug 2013 06:42:44 GMT

You should not rename the fields in the intervalmatch load. Just load your first two tables, and then

IntervalMatch:

IntervalMatch (CreatedDate)

Load distinct StartDate, EndDate resident id2;

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

HIC

Re: interval match

Anonymous — Fri, 09 Aug 2013 07:46:11 GMT

Thanks for your reply.In that case it could appear looping chain of synonym

id(id1)-id(id2)

and id2 with interval match table and id1 with interval match table

Re: interval match

hic — Fri, 09 Aug 2013 07:53:34 GMT

You have a field ID in both the event table (id1) and the interval table (id2). You will get a circular reference unless you rename one of the two. So do that first.

Then you should have a data model similar to the picture in the blog post when you are done.

HIC