Call Duration Format Calculations in Qlikview

[#1]

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.

[#2]

Hi Richard,

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

Good luck!

Rainer

[#3]

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...

[#4]

Richard,

please attach a qlikview file with some data in it.

Thank´s.

Rainer

[#5]

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

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

[#6]

Richard,

maybe it´s to big.

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

Rainer

[#7]

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?

[#8]

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

[#9 · Accepted solution]

Hi Richard,

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

Rainer

[#10]

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