How to create a custom table with time-slots like 08:00 - 09:00, 09:00 - 10:00

[Bitmuster]

Hi all, 

I am new to Qlik and would like my table below

Default Table

to look like this:

Wanted look

I would like to see the revenue per hour; as seen in the table above I would need 10 timeslots and would like to accumulate the revenues for those slots. Would it be better/easier to join time and date to one datetime-field? 

Do you have any suggestions how to solve this via Qlik?

Thank you in advance!

[Or]

Load *, Hour(Time) as Hour

From YourTable;

You can then use Hour as your dimension alongside date.

[salonicdk28 · Accepted solution]

Hi,

You can create bucket or grouping based on your requirement like below in your script editor-

IF(Time>='8:00' and Time<='9:00','08:00-09:00',IF(Time>='9:00' and Time<='10:00','09:00-10:00',
IF(Time>='10:00' and Time<='11:00','10:00-11:00'))) as NewTime

[Bitmuster]

Thank you for the tipp regarding buckets. Never heard about that before... It works!!!