Discussion Board for collaboration related to QlikView App Development.
Interval match is used to link/match a..discrete numeric values to one or more numeric values.
such as...date,time stamp..etc.,
pick() function is alternative to the if condition
Check this simple example related to the Interval Match from Qlik Help
LOAD * INLINE [
Start, End, Order
01:00, 03:35, A
02:30, 07:58, B
03:04, 10:27, C
07:23, 11:43, D
LOAD * INLINE [
Time, Event, Comment
00:00, 0, Start of shift 1
01:18, 1, Line stop
02:23, 2, Line restart 50%
04:15, 3, Line speed 100%
08:00, 4, Start of shift 2
11:43, 5, End of production
IntervalMatch (Time) LOAD Start, End Resident OrderLog;
Interval match is used to match the numeric values.
if you take a..data like this,
load * inline [ Grade,Start,End
load * inline [ Marks,SId
without using any interval match function is going to get result like this:
without interval match is going to assign the all grades for each and every student in that list like below,
Result:(without interval match) :
in this type of scenarios we can use interval match function to get better and correct results.
Here..from our example Marks is the dimension which is changing ...toward the students,
based on the student performance marks are going to change for every one..because
we are applying interval match function to the marks dimension,
based on start and end marks from Grades table.
then it is going ti give the correct result as fallows:
Result:(with interval match)
if you have any scd you can apply interval match.