Help to create a total duration field

[#1]

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!

[sunny_talwar]

Can you try this:

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

[Kushal_Chawda]

try this as well

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

[#4]

[#5]

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

[#6]

Hi Sunny! Thanks for your help,

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

[#7]

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)

[#8]

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)

[sunny_talwar · Accepted solution]

What about this:

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