We are attempting to build a FS Monitor application. The data would look as below:
A
2762001
8/2/2013 12:41:08 PM
39034
11:58:02 AM
A
5361
8/22/2013 10:36:26 AM
84
10:31:11 AM
A
6335
8/22/2013 10:36:12 AM
98
10:31:11 AM
A
14695
8/22/2013 10:36:20 AM
84
10:31:11 AM
A
17231
8/22/2013 10:36:06 AM
98
10:31:11 AM
A
5531
8/22/2013 11:23:36 AM
84
11:18:19 AM
A
6533
8/22/2013 11:23:22 AM
98
11:18:19 AM
A
14872
8/22/2013 11:23:30 AM
84
11:18:19 AM
A
17405
8/22/2013 11:23:10 AM
98
11:18:19 AM
B
80226267
8/5/2013 11:37:02 AM
199999
11:21:55 AM
C
141472
8/1/2013 12:19:38 PM
1045
11:21:55 AM
C
467
8/22/2013 10:36:56 AM
3
10:31:11 AM
C
919
8/22/2013 10:36:50 AM
3
10:31:11 AM
C
475
8/22/2013 11:24:06 AM
3
11:18:19 AM
C
927
8/22/2013 11:24:00 AM
3
11:18:19 AM
D
127
8/22/2013 10:37:26 AM
1
10:31:11 AM
D
357
8/22/2013 10:37:20 AM
1
10:31:11 AM
D
131
8/22/2013 11:24:36 AM
1
11:18:19 AM
D
361
8/22/2013 11:24:30 AM
1
11:18:19 AM
A
686
8/22/2013 11:19:48 AM
11
11:15:03 AM
A
1713
8/22/2013 11:20:02 AM
30
11:15:03 AM
A
1970
8/22/2013 11:19:44 AM
11
11:15:03 AM
A
5034
8/22/2013 11:19:56 AM
30
11:15:03 AM
D
164
8/22/2013 11:20:50 AM
2
11:15:03 AM
D
484
8/22/2013 11:20:46 AM
2
11:15:03 AM
A
566
8/22/2013 11:14:04 AM
11
11:09:34 AM
A
1403
8/22/2013 11:14:20 AM
30
11:09:34 AM
A
566
8/22/2013 11:26:26 AM
11
11:22:02 AM
A
1403
8/22/2013 11:26:42 AM
30
11:22:02 AM
I need to aggregate all the records for each 15 minute interval.by data source type. i.e., I need one record for each data source type for all records between 11:00 to 11:15, 11:15 to 11:30 and so on..
How can i achieve this in qlikview. Please provide your thoughts around this...
