8 Replies Latest reply: Apr 2, 2016 10:47 AM by Sunny Talwar

# Help to create a total duration field

Hi all,

I am new to Qlik software, currently, I am trying to create a total duration field by multiplying fields of 'duration' and 'frequency'. (Please see attached file, I would like to add this column to my table and I have tried to add a measure/dimension by writing the expression =Extension(call duration)*Call Skills (frequency) but it shows as nill...

E.g. the first line would be 0:00:00 * 38 = 0:00:00, the second would be 0:00:01 * 51 = 0:00:51, etc

I'm sure this is basic!, but i'd really appreciate your help!

• ###### Re: Help to create a total duration field

Can you try this:

=Time(Time#(Extension, 'h:mm:ss') * [Call Skills], 'h:mm:ss')

• ###### Re: Help to create a total duration field

Hi Sunny! Thanks for your help,

I'm sure it is simple, but the expression did not work sadly

• ###### Re: Help to create a total duration field

I'm not sure if it is because my first field is AGENT ID, im not sure if that needs to be taken into consideration.

So i Have Agent ID, Duration and frequency (see image)

• ###### Re: Help to create a total duration field

=Time(Time#(Extension, 'h:mm:ss') * Count([Call Skills]), 'h:mm:ss')

• ###### Re: Help to create a total duration field

try this as well

Interval(frac(Time#(Extension,'hh:mm:ss')*[Call Skills]),'hh:mm:ss')

• ###### Re: Help to create a total duration field

I'm not sure if it is because my first field is AGENT ID, im not sure if that needs to be taken into consideration.

So i Have Agent ID, Duration and frequency (see image)

• ###### Re: Help to create a total duration field

Hi Kush, as you can see it populates nothing on the table

I'm sure it is simple, but the expression did not work sadly