topic Associate a single ID with multiple dates. Is this IntervalMatch?? in QlikView https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502027#M187524 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>My challenge is to <STRONG>associate a single CaseNum with every single day in my master calendar that is between StartDate and EndDate</STRONG>. That way on the front end, when you select a date, all cases that are "in flight" will appear in my resulting dataset.</P><P></P><P>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?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 13 Jan 2014 23:07:09 GMT scotthan 2014-01-13T23:07:09Z Associate a single ID with multiple dates. Is this IntervalMatch?? https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502027#M187524 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>My challenge is to <STRONG>associate a single CaseNum with every single day in my master calendar that is between StartDate and EndDate</STRONG>. That way on the front end, when you select a date, all cases that are "in flight" will appear in my resulting dataset.</P><P></P><P>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?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 13 Jan 2014 23:07:09 GMT https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502027#M187524 scotthan 2014-01-13T23:07:09Z Re: Associate a single ID with multiple dates. Is this IntervalMatch?? https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502028#M187525 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Did you read this paper "Creating Reference Dates from Intervals"?</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates</A></P><P>It seems very similar to your case</P><P></P><P>Regards</P></BODY></HTML> Mon, 13 Jan 2014 23:28:15 GMT https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502028#M187525 maxgro 2014-01-13T23:28:15Z Re: Associate a single ID with multiple dates. Is this IntervalMatch?? https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502029#M187526 <HTML><HEAD></HEAD><BODY><P>A+</P></BODY></HTML> Mon, 13 Jan 2014 23:54:36 GMT https://community.qlik.com/t5/QlikView/Associate-a-single-ID-with-multiple-dates-Is-this-IntervalMatch/m-p/502029#M187526 scotthan 2014-01-13T23:54:36Z