O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

The IntervalMatch function

Employees with IDs 275 and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required