Interval Match - QlikView Tutorial - Session 11
In this session you will learn about Interval Match
Intervalmatch
--------------------
Useful to link discrete numeric values to one or more discrete numeric intervals
Conditions
----------------
Tables must be loaded before writing Intervalmatch Statement
One Table must contain 'Start' and 'End' Type of Fields
Intervals must be closed
1-10 9
11-20 16
21-30 24 27
24
16
9
27
OrderLog - Order,Start,End
EventLog - Event, Time,Comment
Intervalmatch(Time) Load Start,End Resident OrderLog;