Showing result in a time based buckets format

hibhardwaj — Tue, 18 Jun 2013 21:42:00 GMT

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:

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.

Re: Showing result in a time based buckets format

nagaiank — Tue, 18 Jun 2013 22:42:10 GMT

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

hibhardwaj — Tue, 18 Jun 2013 23:17:49 GMT

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