topic Re: How does one form bins for a time dimension? in QlikView

How does one form bins for a time dimension?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How does one form bins for a time dimension?

sunny_talwar — Mon, 20 Mar 2017 13:35:54 GMT

Check these:

Buckets

Dynamic Time Intervals Using Calculated Dimension In QlikView - QlikView Blog, QlikView Videos and Tips at QlikShare

Re: How does one form bins for a time dimension?

Mon, 20 Mar 2017 13:40:51 GMT

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)

)

Re: How does one form bins for a time dimension?

sunny_talwar — Mon, 20 Mar 2017 15:56:24 GMT

Super