topic Re: Total time in Hours format in QlikView

Total time in Hours format

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have kpi like

Total Email handle time

I am using the logic is

sum({<type={'Email'}>}[InteractionDurationSeconds])

but I am getting the result like 7.1 M

but I need the result like 10:45:45 like this this time is not exact output but my outcome should be like that

Anyone help on this?

Thanks

Sony

prat1507 — Fri, 01 Jun 2018 10:20:17 GMT

So you're getting the results as total sum of seconds and you want it in HH:MM:ss format, am I right?

Probably this

=time(sum({<type={'Email'}>}[InteractionDurationSeconds])/3600,'hh:mm:ss')

Regards

Pratyush

tresB — Fri, 01 Jun 2018 10:40:10 GMT

Try using interval(), like:

Interval(sum({<type={'Email'}>}[InteractionDurationSeconds]) , 'hh:mm:ss')