Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.