Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Total time in Hours format

Hi all,

I have kpi like

   

Total Email handle time

I am using the logic is   

   

sum({<type={'Email'}>}[InteractionDurationSeconds]) 

but I am getting the result like 7.1 M  

but I need the result like     10:45:45   like this   this time is not exact output but my outcome should be like that

Anyone help on this?

Thanks

Sony

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try using interval(), like:

Interval(sum({<type={'Email'}>}[InteractionDurationSeconds]) , 'hh:mm:ss')

View solution in original post

2 Replies
prat1507
Specialist
Specialist

So you're getting the results as total sum of seconds and you want it in HH:MM:ss format, am I right?

Probably this

=time(sum({<type={'Email'}>}[InteractionDurationSeconds])/3600,'hh:mm:ss')


Regards

Pratyush

tresesco
MVP
MVP

Try using interval(), like:

Interval(sum({<type={'Email'}>}[InteractionDurationSeconds]) , 'hh:mm:ss')