Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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

Not applicable

That did the trick. Thanks a lot!