Hi All,
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...
Regards,
Amar
