topic Problem calculating Time in QlikView

Problem calculating Time

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

Hi,

Please see below. I have calculated time intervals for a particular user.

When I try and sum the times, it calculates incorrectly. Could someone please assist.

my expression is sum(TASKTIME) And the first screenshot is just TASKTIME.

Please could you help in this regard?

i have tried changing the format to intervals in the expression, it yields a different result altogether.

Any ideas? Thanks in advance!

Anil_Babu_Samineni — Thu, 11 May 2017 08:18:49 GMT

May be this?

sum({<USER = {'EMADIBANA564'}>}TASKTIME)

Anonymous — Thu, 11 May 2017 08:21:08 GMT

I cannot use set analysis because the calculation has to be done for a number of users. Cannot hardset the user

Anil_Babu_Samineni — Thu, 11 May 2017 08:22:55 GMT

I am not fully understand, May be can you explain bit more. May be try this?

If(USER = 'EMADIBANA564', Sum(TASKTIME))

Anonymous — Thu, 11 May 2017 08:25:17 GMT

sunny_talwar — Thu, 11 May 2017 08:32:35 GMT

May be try this

Interval(Sum(Frac(TASKTIME)), 'h:mm:ss')

MindaugasBacius — Thu, 11 May 2017 08:56:41 GMT

Might work:

sum(distinct TASKTIME)