Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi Stefan,
can you explain me how the evaluated numbers links with time ? what is exact logic behind the operation of 1/12 ?
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).