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: 
vengadeshpalani
Creator
Creator

How can i change Number to Hour format

Hi All,

How can i change Number to Hour format

Screenshot_3.png

Data
9.0
9.5
10.0
10.5
11.0
11.5
12.0
12.5
13.0
13.5
14.0
1 Solution

Accepted Solutions
sunny_talwar

Just do this

Time(Data/24, 'h:mm') as Data

View solution in original post

2 Replies
sunny_talwar

Just do this

Time(Data/24, 'h:mm') as Data

marcus_sommer

Try it with: time(1/24 * [Data]) as [Hour]

- Marcus