topic Re: Interval Match Vs Class function in QlikView

Interval Match Vs Class function

Wed, 21 Mar 2012 05:34:17 GMT

Hi All,

Can anyone explain what is the difference between interval match and class function?

Regards,

Kush

Interval Match Vs Class function

dirk_konings — Wed, 21 Mar 2012 11:37:17 GMT

With intervalmatch you have a table with lower and upper bound. Like 1 till 3, 4 till 6, 7 till 9, 10 till 15, 16 till 20, ...With Class each bound has the same interval (ex. 5 - 1 till 5, 6 till 10, 11 till 15, 16 till 20, ...)

Re: Interval Match Vs Class function

gauravkhare — Tue, 10 Apr 2012 12:12:14 GMT

Hi there,

can u plsss elaborate your suggestion.. I mean in a manner which can be more understanding.. Thanks in advance

Interval Match Vs Class function

SunilChauhan — Tue, 10 Apr 2012 12:20:55 GMT

if you have a filed then we can divide it into ranges ussing class function

ex:

a 1 2 3 4 5 6 7 8 9 10

if i write Class(a,2) then result will be

0 <= x < 2

2 <= x < 4

4 <= x < 6

6 <= x < 8

8 <= x < 10

10 <= x < 12

12 <= x < 14

i mean it create you a bucket

where as Interval match matches time with intervals

for example

OrderLog
Start	End	Order
01:00	03:35	A
02:30	07:58	B
03:04	10:27	C
07:23	11:43	D

EventLog
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

First load the two tables as usual, then link the field Time to the time intervals defined by the fields Start and End:

Select * from OrderLog;

Select * from Eventlog;

IntervalMatch ( Time ) select Start, End from OrderLog;

The following table box could now be created in QlikView:

Tablebox
Time	Event	Comment	Order	Start	End
00:00	0	Start of shift 1	-	-	-
01:18	1	Line stop	A	01:00	03:35
02:23	2	Line restart 50%	A	01:00	03:35
04:15	3	Line speed 100%	B	02:30	07:58
04:15	3	Line speed 100%	C	03:04	10:27
08:00	4	Start of shift 2	C	03:04	10:27
08:00	4	Start of shift 2	D	07:23	11:43
11:43	5	End of production	D	07:23	11:43

hope this helps