Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Time: more than 24 hours

Hi,

I have a throughputtime computed as the difference between starttime and  endtime, endtime and starttime are both formatted as dates:

time(Endtime-Starttime).

This works great until the throughputtime is more than 24 hours.. 25 hours and 10 minutes will now be displayed as 1 hour and 10 minutes.

How could I work around this issue? I don't want to add the difference in days because that will mess up other computations.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

use interval() instead of time()

interval(Endtime-Starttime)

View solution in original post

2 Replies
Highlighted
MVP
MVP

use interval() instead of time()

interval(Endtime-Starttime)

View solution in original post

Highlighted
Not applicable

That did the trick. Thanks a lot!