How does one form bins for a time dimension?

[#1]

Hi there i am new to the forum and have learnt a lot through this forum. i hope that someone would be able to assist me with the problem i am facing.

i have time stamped data and would like to bin these times into intervals (eg. 00:00-01:00 , 01:00-02:00 and so on) in order to create a historgram for sales over a 24 hour period

[sunny_talwar]

Check these:

Buckets

Dynamic Time Intervals Using Calculated Dimension In QlikView - QlikView Blog, QlikView Videos and T...

[#3]

Thanks Sunny. I was able to determine bin the time intervals using

=Dual(

      Interval(SubField(Class([Time], 1/24),'<= x <',1),'hh:mm')&' - '&

      Interval(SubField(Class([Time], 1/24),'<= x <',2),'hh:mm'),

      Class([Time], 1/24)

     )

[sunny_talwar]

Super