topic Re: Creating an average timeline based on datetime in QlikView

Creating an average timeline based on datetime

Thu, 17 Apr 2014 14:54:51 GMT

Hi,

I have a dataset from a callcenter with all inbound calls in 2013 (phonenumber, number called, time called, call duration, wait time, call forwarding etc).

I have a datetime field which shows the date and time the call was received (eg 2-1-2013 7:38:07). Now I want to create a timeline chart that shows a line displaying the average number of calls on a time (starting at 07:00 and ending at 19:00).

What is the easies way to do this? I've already started creating a master calendar.

Thanks in advance,

Re: Creating an average timeline based on datetime

maxgro — Thu, 17 Apr 2014 16:32:34 GMT

try this

Re: Creating an average timeline based on datetime

Fri, 18 Apr 2014 07:46:29 GMT

Thanks but that's not really what I am looking for. Here is an example of some DateTime values:

DateCalc

12-06-13 12:21:26

12-06-13 12:22:56

12-06-13 12:40:17

12-06-13 12:47:36

12-06-13 13:11:46

12-06-13 13:12:13

12-06-13 13:23:34

12-06-13 13:33:28

12-06-13 13:34:09

12-06-13 13:35:19

12-06-13 13:38:03

12-06-13 13:39:57

12-06-13 13:41:57

12-06-13 13:51:16

12-06-13 13:54:13

12-06-13 14:00:46

12-06-13 14:15:30

12-06-13 14:16:08

12-06-13 14:21:52

12-06-13 14:22:32

12-06-13 14:34:26

12-06-13 14:52:43

12-06-13 15:00:30

I think I am going to try to create an expression which only takes hh:mm (14:34) for all values and then use count. Then show the result against a dimension time (based on minutes).

Re: Re: Creating an average timeline based on datetime

Fri, 18 Apr 2014 09:36:32 GMT

I've create a new Dimensions in the script based on DateTime called Time: =Time(Hour(DateTime)&':' & Minute(DateTime)) as Time;

Now I've created a line chart with Time as Dimension and a simple expression: =Count(Time)

This gets the results I want but I am still curious to other solutions people could use.

Re: Creating an average timeline based on datetime

Mon, 02 Jun 2014 17:47:43 GMT

you can also use the Round function in QlikView if you don't have a lot of data points to get a more even distribution (and you will be better able to see trends)