Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hibhardwaj
Contributor III
Contributor III

Showing result in a time based buckets format

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:

CartonTimeScan
ABC02:30
DEF02:45
GHI03:30
JKL03:45
MNO03: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 SlotNumber of Cartons
02:00 - 03:002
03:00 - 04:003

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.

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

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

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

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

hibhardwaj
Contributor III
Contributor III
Author

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