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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
tincholiver
Creator III
Creator III

time format

Hello everyone:

I don't know how to solve the following time format, which is the following.

1.50 is the value of the field, but it should be read as 1:30 since 50 is the percentage not the minutes.

Any function to solve this?

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

If you simply divide by 24 and display as duration (QS) or Interval (QV), this should be correct as-is.

Or_0-1656429575543.png

 

View solution in original post

2 Replies
Or
MVP
MVP

If you simply divide by 24 and display as duration (QS) or Interval (QV), this should be correct as-is.

Or_0-1656429575543.png

 

tincholiver
Creator III
Creator III
Author

I work perfectly.
In the script add :

interval(time/24) and that's it, I'm converted!

Thanks a lot