topic Re: Creating Time Bands in QlikView

Creating Time Bands

Wed, 28 Mar 2012 08:49:13 GMT

Hi All

What i am looking to do is create time bands in one of my applications to see when are our most busy periods of the day. I have got a date field that is associated to our customer ID field so i can already count how many customers we have on a particular day but this field also contains the time. I am looking to create set time bands such as 9am till 11am and so on so i can count the number of customers in each time band. What would be the best way in QlikView to achieve this?

Thanks

Emma

Re: Creating Time Bands

swuehl — Wed, 28 Mar 2012 10:52:54 GMT

emmabirdsey,

there are several ways of doing this.

For example, you could create a calculated dimension, where you create the buckets you need, e.g. by using the class function or some nested if() statements (lattter have the advantage that you can use different intervals and better control your labels).

Or you could use INTERVALMATCH load prefix to link your timestamps to some given intervals.

Please have a look at attached sample for a demonstration of both methods (and I probably missed some more).

Hope this helps,

Stefan

Re: Creating Time Bands

manojkulkarni — Thu, 27 Aug 2015 05:00:30 GMT

hi Stefan,

can you explain me how the evaluated numbers links with time ? what is exact logic behind the operation of 1/12 ?

Re: Creating Time Bands

swuehl — Thu, 27 Aug 2015 18:33:45 GMT

Time in QV is stored internally as fraction of a day.

So a 2:00 AMl is the same as 2 hours / 1 day = 2 hours / 24 hours = 1 / 12.

Similar for calculating intervals (difference between points in time).