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.
You may use Class() function. A sample application is attached.
You may use Class() function. A sample application is attached.
Thank You very much! It was very helpful Sir...