Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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.

View solution in original post

hibhardwaj
Contributor III
Contributor III

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