Associate a single ID with multiple dates. Is this IntervalMatch??

[scotthan]

Hi,

Let's say I have two simple tables. One is a fact table with a CaseNum, StartDate, and EndDate. The other is my Master Calendar, set up properly, which has one record for each day beginning from the first StartDate through the max EndDate.

My challenge is to associate a single CaseNum with every single day in my master calendar that is between StartDate and EndDate. That way on the front end, when you select a date, all cases that are "in flight" will appear in my resulting dataset.

I tried intervalmatch and couldn't get it. I read Henric's IntervalMatch paper and didn't see this example outlined so I am now wondering if it's not an intervalmatch at all! Does anyone have any ideas?

Thanks!

[maxgro · Accepted solution]

Hi

Did you read this paper "Creating Reference Dates from Intervals"?

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

It seems very similar to your case

Regards

[scotthan]

A+