Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Difference between Time and Interval

Hi guys,

Normally "interval" would give me the same result as "time":

interval(Sum(60*length/[link.curent_speed])/(60*24),'m:ss')

time(Sum(60*length/[link.curent_speed])/(60*24),'m:ss')

Recently I've noticed a difference.  I got a 48:09 as result for a "time" and -11:50 for "interval".

Do any of you know the difference between the two functions?

Thanks

 

Labels (3)
2 Replies

Re: Difference between Time and Interval

It gave you a negative number for interval?

In general Time is what you see in a clock, whereas Interval is duration. Basically, You started at 6 am and ended something at 7 am.... so it took you 1 hour... whereas time is 6 am or 7 am...

Not sure if this was clear enough... but that is how I see it
Partner
Partner

Re: Difference between Time and Interval

I stil don't know why I would get a negative number for an interval, but I've found out that if I use "time" and the result is bigger than 60 minutes, only the minutes over the 60 minutes get displayed.

E.g.

Interval - Time 

14:00 - 14:00

68:00 - 8:00

72:30 - 12:30