Difference between Time and Interval

Cbhuvi27 — Wed, 15 Nov 2023 12:06:16 GMT

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

Re: Difference between Time and Interval

Or — Wed, 15 Nov 2023 13:06:29 GMT

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.

topic Difference between Time and Interval in App Development

Difference between Time and Interval

Re: Difference between Time and Interval