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: 
berryandcherry6
Creator II
Creator II

aggregate of time in qlik

Hi,

i have table like below

unique_id
subjects nametime taken to complete
23advertise subject0:10:30
23modern tech subject0:1:22.111
23astrologael subject0:0:16.481
23computer subject00:00:00.0

i want output like below

unique_idtime taken to complete
230:1:68.592

Here i want to aggregate time taken by unique_id.

How could i do this?

1 Solution

Accepted Solutions
sunny_talwar

May be like this

Time(Sum(TimeTakenToComplete), 'h:mm:ss:fff')

View solution in original post

4 Replies
sunny_talwar

May be like this

Time(Sum(TimeTakenToComplete), 'h:mm:ss:fff')

parthesh
Creator
Creator

here i understand that you want to aggregate time column by Unique_id, but i dont understand

by which formula you are getting " 0:1:68.592".

zebhashmi
Specialist
Specialist

Sum(Time(TimeTakenToComplete,'h:mm:ss:fff')

berryandcherry6
Creator II
Creator II
Author

Hi sunny,

Thanks. That worked.

For aggregation by unique_id :

Aggr(Time(Sum(TimeTakenToComplete), 'h:mm:ss'),unique_id)