Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i have some problems with the intervalmatch function. I have load a table with the interval boundaries. This are time intervals. Here you can see as an example of two of thie entries.
0 - 15 minutes 00:00:00 (0) 00:14:59 (0.010405092592593)
15 - 30 minutes 00:15:00 (0.010416666666667) 00:29:59 (0.020821759259259)
Then i have a table with start time and stop times and a calcualtes duration between start and stop.
You can see that the Entries 1-4 matched, the entries 5-9 and 10-13 dosn't matched and 14-19 matched.
1 0 - 15 minutes 2010-10-07 10:34:22 2010-10-07 10:49:21 (14:59) 0.010405092587462
2 0 - 15 minutes 2010-06-06 07:07:58 2010-06-06 07:22:57 (14.59) 0.010405092587462
3 0 - 15 minutes 2010-05-27 22:55:31 2010-05-27 23:10:30 (14:49) 0.010405092587462
4 0 - 15 minutes 2010-04-21 07:02:00 2010-04-21 07:16:59 (14:59) 0.010405092587462
5 2012-03-02 12:49:34 2012-03-02 13:04:33 (14:59) 0.010405092594738
6 2012-03-05 11:09:47 2012-03-05 11:24:46 (14:59) 0.010405092594738
7 2012-03-09 12:20:15 2012-03-09 12:35:14 (14:59) 0.010405092594738
8 2012-02-01 20:24:56 2012-02-01 20:39:55 (14:59) 0.010405092594738
9 2012-02-02 13:10:26 2012-02-02 13:25:25 (14:59) 0.010405092594738
...
10 2010-08-04 14:52:12 2010-08-04 15:07:12 (15:00) 0.010416666664241
11 2010-08-20 11:20:37 2010-08-20 11:35:37 (15:00) 0.010416666664241
12 2010-05-21 09:37:28 2010-05-21 09:52:28 (15:00) 0.010416666664241
13 2010-04-28 18:07:00 2010-04-28 18:22:00 (15:00) 0.010416666664241
14 15 - 30 minutes 2012-03-10 09:07:31 2012-03-10 09:22:31 (15:00) 0.010416666671517
15 15 - 30 minutes 2012-03-12 10:39:08 2012-03-12 10:54:08 (15:00) 0.010416666671517
16 15 - 30 minutes 2012-03-27 07:43:31 2012-03-27 07:58:31 (15:00) 0.010416666671517
17 15 - 30 minutes 2012-02-12 11:47:13 2012-02-12 12:02:13 (15:00) 0.010416666671517
18 15 - 30 minutes 2012-02-13 11:12:18 2012-02-13 11:27:18 (15.00) 0.010416666671517
19 15 - 30 minutes 2012-02-20 12:28:05 2012-02-20 12:43:05 (15:00) 0.010416666671517
I think the problem is the internal presentation of time values. Not as an internder (seconds), as an part of a day (1 s = 1/864000).
If there any possibility to change the behavier of the intervalmatch function?
Regards, Henry
Yes, could be a problem of your internal representation.
Please have a look at
http://qlikviewnotes.blogspot.de/2011/10/correct-time-arithmetic.html
and try creating your interval bounderies using time functions.
Regards,
Stefan