Does a QlikView operation exist that cuts a time range in pieces (hours)?

[#1]

My data are

Time from	Time until	Hours
07:00	10:00	3
08:00	10:00	2
09:00	12:00	3

I want to display:

Label “Time space”	Count
“7-8”	1
“8-9”	2
“9-10”	3
“10-11”	1
“11-12”	1

How can I achieve this?

[hic]

There is a fucntion Class() that can classify numeric data into same-size classes.

But if you want a more general solution, you should look at IntervalMatch.

HIC

[swuehl · Accepted solution]

I think also another of Henric's classic blog posts might apply:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates