Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem calculating Time

Hi,

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

cap555.JPG

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

capp3.JPG

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.

capp66.JPG

Any ideas?  Thanks in advance!

6 Replies
Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

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

Anil_Babu_Samineni

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

CAPP999.JPG

sunny_talwar

May be try this

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

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Might work:

sum(distinct TASKTIME)