Showing result in a time based buckets format

[hibhardwaj]

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.

[nagaiank · Accepted solution]

You may use Class() function. A sample application is attached.

[hibhardwaj]

Thank You very much! It was very helpful Sir...