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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get time from numeric start value qlikview

Hi all,

How do I get the timestamp from values like 0....420, 421, 422, 423....1430 where the values in the interval is minutes and the starttime is from 00:00 (12:00 a.m)?

Example 420 = 07:00 (7:00 a.m) and 1400 = 23:33 (11:33 p.m)

Thanks for suggestions

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

SImply this:

=Time(Value / 1440)

(because there are 24*60 (1440) minutes per day)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
avinashelite

try like this:

=interval(interval#(420, 'm'), 'hh:mm')

jonathandienst
Partner - Champion III
Partner - Champion III

SImply this:

=Time(Value / 1440)

(because there are 24*60 (1440) minutes per day)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MK_QSL
MVP
MVP

=Time(YourFieldName/60/24)