The IntervalMatch function
The IntervalMatch function is used to match a single value in a table to an interval or range of values in another table. This scenario occurs in real time when you are trying to match a date in one table, which falls between two dates in another table. Another example will be matching the number of shifts falling in a time period of, say, eight hours.
The IntervalMatch function is also useful in handling slowly changing dimensions (SCD), specifically Type 2.
Slowly changing dimension Type 2 is used to track the historical information of the data. For example, see the following employee records:
Employees with IDs 275 and ...
Get QlikView Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
