topic Call Duration Format Calculations in Qlikview in QlikView

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 11:26:25 GMT

Hi.

I'm trying to get the durations of calls right for our callcentre model. The way we get Callduration from the database is eg. 00:11, 14:56 etc. When i do a sum of the call duration in an expression it doesn't come right as you can see below. It seems like such a simple thing but i've tried everything and it doesn't look right.

I've also created a live call duration 'tick over' (below) - I've tried to say DD:HH:MM:SS

But because the format in which it comes in (mm:ss), i don't know if it is right, it never shows the seconds which i know t should.

Please could someone help me with this.

P.S. Sorry if this has already been brought up.

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 11:45:07 GMT

Hi Richard,

see the attached file for more details. And of course see also QV Help: TIME.

Good luck!

Rainer

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 12:02:27 GMT

Hi Rainer,

Looked at the attached example, the only difference is, in the example the call duration was brought in the total amount of seconds eg. 657 seconds, so all he did was convert it to time and it was fine..i receive my call duration in mm:ss. How do i calculate the sum of that in an expression, i've been saying sum(callduration) (as is) and you can see by the examples above that the totals do not add up and for the 'live tick over' i do not receive seconds. The Time functions make things worse.. Would you like me to send more examples of what i am talking about?

Thanks for your quick response...

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 12:14:41 GMT

Richard,

please attach a qlikview file with some data in it.

Thank´s.

Rainer

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 12:53:22 GMT

file:///C:/Users/Richard/Desktop/Duration_Example.qvw

It Won't let me insert the file, says it is not allowed..

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 13:36:42 GMT

Richard,

maybe it´s to big.

Another option will be an excel file with a few records.

Rainer

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 13:55:49 GMT

Don't know what the problem is.. Anyway, you could use this:

LOAD * INLINE [

AgentName, CallDuration

Tom, 05:45

***, 00:01

Harry, 15:59

Harry, 00:35

Tom, 08:02

***, 12:26

Tom, 04:37

Harry, 01:10

***, 01:24

Harry, 45:56

Tom , 21:48

***, 06:10

Tom, 00:02

Tom, 06:07

];

And then try and create the reports i showed you in the beginning?

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 13:59:49 GMT

Guess they quite strict on the language.. I'm sure you could edit that though

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 15:38:20 GMT

Hi Richard,

so far I see you are now a step closer to reach your goal.

Rainer

Call Duration Format Calculations in Qlikview

Thu, 21 Jan 2010 15:49:50 GMT

Rainer, you're a genius, thanks so much for all your help, really appreciate it..

Call Duration Format Calculations in Qlikview

daniel_wennstro — Sun, 13 Mar 2011 12:29:02 GMT

You can use interval() to do that.

if you get sum(Duration) and duration are in format "interval" (make the formatting in the script). then you will be able to get duration of more than 24 hours, and also use a format like DD:hh:mm:ss or D hh:mm:ss.

Note, if you got the call length in seconds, you will have to divide it by 86400 to get it in time format: intervall([Duration seconds] /86400)

Br Daniel