Difference between Time and Interval

[Cbhuvi27]

Hello All,

Can you please help me with the difference between time and interval in qliksense ? I gone through so many forums but unable to understand the exact difference.

Hours = 51000

eg :=interval((num#(hours)*MP_1)/1440,'hh:mm') gives 850:00

time((num#(hours)*MP_1)/1440,'hh:mm') gives 10:00

TIA

[Or · Accepted solution]

Interval() and Time() are both formatting functions.

Time() will format something as a 24-hour clock time, ignoring the date aspect if it exists, e.g. Time(Now()) might return 14:25.

Interval() will format something as an interval, which includes any units beyond the 24 hour clock. For example, Interval(Now()) might return something like this:

So essentially, it's the difference between a clock and a stopwatch.

Check the documentation for more information on this.