IntervalMatch

IntervalMatch

Let me explain here the use of Interval Match function why interval match function is used in the Qlikview application. It will used to create a table matching discrete numeric values to one or more numeric intervals.

It must placed before the load statement and syntax is

IntervalMatch (MatchField1, MatchField2) load Column1, Column2, Column3
Resident TableName;

The IntervalMatch prefix transforms the loaded table of intervals to a table that contains an additional column: the discrete numeric data points. It also expands the number of records so that the new table has one record per possible combination of discrete data point and interval.