Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
berryandcherry6
Contributor 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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: aggregate of time in qlik

May be like this

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

4 Replies
MVP
MVP

Re: aggregate of time in qlik

May be like this

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

parthesh
New Contributor III

Re: aggregate of time in qlik

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
Valued Contributor

Re: aggregate of time in qlik

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

berryandcherry6
Contributor II

Re: aggregate of time in qlik

Hi sunny,

Thanks. That worked.

For aggregation by unique_id :

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