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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 .