topic Re: avg in time format in QlikView

avg in time format

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

Hi All,

I am using below expression for avg time in KPI object

Avg({<Type={'Phone'}>}DurationSeconds)

so I want to show in hh:mm:ss format as result

can anyone suggest ?

]

tresB — Tue, 19 Jun 2018 05:30:08 GMT

You can use formatting function around the expression like:

Time( Avg({<Type={'Phone'}>}DurationSeconds) , 'hh:mm:ss')

soniasweety — Tue, 19 Jun 2018 05:31:49 GMT

it is showing wrong result.

tresB — Tue, 19 Jun 2018 05:34:18 GMT

Or, if your output of the expression comes in seconds, you may try like:

Time( Time#(Avg({<Type={'Phone'}>}DurationSeconds) ,'s') , 'hh:mm:ss')

soniasweety — Tue, 19 Jun 2018 05:34:56 GMT

my data base result :

but my qlik result

8348:23:09

soniasweety — Tue, 19 Jun 2018 05:36:45 GMT

this is showing null.

tresB — Tue, 19 Jun 2018 05:39:46 GMT

Trying using floor(), like:

Time( Time#(Floor(Avg({<Type={'Phone'}>}DurationSeconds)) ,'s') , 'hh:mm:ss')

tresB — Tue, 19 Jun 2018 05:54:19 GMT

Another alternative:

Time(Avg({<Type={'Phone'}>}DurationSeconds)/86400 , 'hh:mm:ss')