Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Channa
Valued Contributor 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
agni_gold
Valued Contributor III

Re: Convert Seconds into Hours and Minutes

Channa
Valued Contributor III

Re: Convert Seconds into Hours and Minutes

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
Highlighted

Re: Convert Seconds into Hours and Minutes

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
Valued Contributor III

Re: Convert Seconds into Hours and Minutes

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

Re: Convert Seconds into Hours and Minutes

Should be like this

If(Interval#(FieldName, 's') > MakeTime(2), Red())
Channa
Valued Contributor III

Re: Convert Seconds into Hours and Minutes

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

Re: Convert Seconds into Hours and Minutes

What value do you get for Avg(VOYAGE_ARR_TO_CONTAINER_DISCHARGE)?

Channa
Valued Contributor III

Re: Convert Seconds into Hours and Minutes

i get seconds between tow dates

Channa

Re: Convert Seconds into Hours and Minutes

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