Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Cbhuvi27
Contributor III
Contributor III

Difference between Time and Interval

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

 

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

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:

Or_0-1700051178456.png

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

 

Check the documentation for more information on this.

 

View solution in original post

1 Reply
Or
MVP
MVP

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:

Or_0-1700051178456.png

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

 

Check the documentation for more information on this.