IntervalMatch with additional key leads to "false" matches; circular loop otherwise

Tue, 15 Apr 2014 16:54:43 GMT

Hello. I am struggling with IntervalMatch creating either a circular loop or "false" matches based on which treatment I choose.

For starters, I've modeled heavily from this: IntervalMatch and Slowly Changing Dimensions. My scenario is closest to the "Two interval tables mapped against a common dimension ID and a common time line" example in the linked PDF.

In brief, discrete events (on different inventory items) can share a start and end time, so the bridge table is incorrectly linking different events. When I try to force an InventoryID into both tables, I get circular reference errors.

Please see the attached .QVW. Of note, it is currently set up with the bridge table. You can see how an EventId (which corresponds to only a single InventoryId) is being linked to multiple InventoryIds because their start and end times are the same.

I feel like I'm close, but I've been circling the drain on this for a few days.

Re: IntervalMatch with additional key leads to "false" matches; circular loop otherwise

swuehl — Tue, 15 Apr 2014 17:48:48 GMT

Maybe similar to this?

Re: IntervalMatch with additional key leads to "false" matches; circular loop otherwise

Tue, 15 Apr 2014 19:20:36 GMT

As always, THANK YOU! That worked. I knew I was close.

INNER JOIN in front of the IntervalMatch did the trick, along with using the same name for the additional key.

topic Re: IntervalMatch with additional key leads to "false" matches; circular loop otherwise in QlikView

IntervalMatch with additional key leads to "false" matches; circular loop otherwise

Re: IntervalMatch with additional key leads to "false" matches; circular loop otherwise

Re: IntervalMatch with additional key leads to "false" matches; circular loop otherwise