Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum time duration

Hi everyone, 

I am new in qlikview and I have one problem with adding different durations times in this format 'YYYY/MM/DD HH:MM:SS.fff'. In this field I have years, months and days with 0 (i.e 0/0/0 03:01:00)  and I do believe this is the issue. Can you help me solved it?

Thanks in advance..

Best regards

José João Grave

2 Replies
swuehl
MVP
MVP

Just use the time part:

=sum(interval#( right( YourField, 8), 'hh:mm:ss'))

MarcoWedel

Hi,

one solution could be also:

=Interval(Sum(SubField(duration_txt,' ',-1)))

QlikCommunity_Thread_167858_Pic1.JPG

hope this helps

regards

Marco