Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Channa
Specialist III
Specialist III

Convert Seconds into Hours and Minutes

I am getting time difference in seconds from data base i need to convert into HH:MM

 

Channa
Labels (1)
11 Replies
Channa
Specialist III
Specialist III
Author

Thank you bro,

 

i don't want to show seconds just HH:MM

i use those expressions it is showing like 12:76 ..i dont want to show 76 it should be below 60

Channa
sunny_talwar

Would you be able to share an image of what you have right now? You can try something like this if you have seconds like this 360 and you want to show 00:06

=Interval(Interval#(360, 's'), 'hh:mm')
Channa
Specialist III
Specialist III
Author

Sunny thank you

 

it works i have to add KPI color like more than 2 hours i want to show as red color

 

can you please help me with KPI color

Channa
sunny_talwar

Should be like this

If(Interval#(FieldName, 's') > MakeTime(2), Red())
Channa
Specialist III
Specialist III
Author

i tried 

 

=If(Interval#(AVG(VOYAGE_ARR_TO_CONTAINER_DISCHARGE), 's') > MakeTime(2), Red(),Green())

 

08:22 

showing in Green color it should be red

Channa
sunny_talwar

What value do you get for Avg(VOYAGE_ARR_TO_CONTAINER_DISCHARGE)?

Channa
Specialist III
Specialist III
Author

i get seconds between tow dates

Channa
sunny_talwar

Hahahaha what is the value my friend? Is it giving you a value of less than 7200 (60*60*2)