Discussion Board for collaboration related to QlikView App Development.
Hi, this q has not been answered in this forum but many people must struggle with this:
Q: how to calculate time diff in script?
Ex Calc time between 2 loops. This is how I do it. Any comments and risk with this? I notcied that neg values doesnt go well, so u have to check for that or trust the data.
I would appreciate a "TimeDiff" function!
Use the Interval() function
Interval(arrival_loop1 - departure_loop1, 'hh:mm:ss')
View solution in original post
Big THX!! More elegant solution.
This solution will crush when departure is exactly at midnight or after it as Svante used time not timestamp.