Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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!

1 Solution

Accepted Solutions

Re: Help to create a total duration field

What about this:

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

8 Replies

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

try this as well

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

Not applicable

Re: Help to create a total duration field

test2.png

Not applicable

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

Not applicable

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

Not applicable

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) agent ID.png

Highlighted
Not applicable

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) agent ID.png

Re: Help to create a total duration field

What about this:

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