I am trying to load a script that would get the data for a database table. The SQL for the table load looks like this:
CartonData:
Load
Carton,
TimeScan
From DataBase;
Its running fine and the resulting table from this data load would look like this:
| Carton | TimeScan
|
|---|
| ABC | 02:30 |
| DEF | 02:45 |
| GHI | 03:30 |
| JKL | 03:45 |
| MNO | 03:55 |
Now I want to show the result in a way that that there are time buckets in the table. The above table should be shown as:
| Time Slot | Number of Cartons |
|---|
| 02:00 - 03:00 | 2 |
| 03:00 - 04:00 | 3 |
I know there has to be a way to do this. Either by adding some code to the script or any other way.
Can you please help me with this. I am sorry if this seems very basic, I am very new to QlikView.
