Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression for sum of time in total column

hI ,

I want sum of time in (hh:mm) in total column . so how we will write expression for summation of time in this format 'hh:mm'Administrator

2 Replies
swuehl
MVP
MVP

time needs to be a field that has a numeric representation, like all date / time values created by QV itself.

See also this for more explanations on the date (and time) functions:

QlikView Date fields

Then, your expression might just look like

=interval( sum(TimeField), 'hh:mm')

Not applicable
Author

HI,

please find an attachment. in this file last column is for time and i want sum of that time in one row so how i will write expression for that .