Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
arpitkharkia
Creator III
Creator III

Convert number to Time 'hh:mm:ss'

Hi all,

I have the following table in which all the data present is in seconds. All the data is generated using sum() function or some basic arithmetic calculation. I want the data in 'hh:mm:ss'  format.

Thanks for the help!

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

You will need to convert the values to QV time values and then format the values to time format.

In each of your expressions that return seconds, convert to QV time by dividing by 24*60*60 = 86400 (seconds per day) and then apply the format hh:mm:ss to the column in the chart properties number tab.

As an example, the expression for Avg Dial time:

     =Avg(....) / 86400   (existing expression divided by seconds per day)

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

View solution in original post

9 Replies
antoniotiman
Master III
Master III

=Time(Time#(19227,'ss'))  -> 05:20:27

Anil_Babu_Samineni

Would you able to provide sample application?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jonathandienst
Partner - Champion III
Partner - Champion III

You will need to convert the values to QV time values and then format the values to time format.

In each of your expressions that return seconds, convert to QV time by dividing by 24*60*60 = 86400 (seconds per day) and then apply the format hh:mm:ss to the column in the chart properties number tab.

As an example, the expression for Avg Dial time:

     =Avg(....) / 86400   (existing expression divided by seconds per day)

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

please note the seconds format in QV is tt

el_aprendiz111
Specialist
Specialist

Hi,

=Interval(interval#(ceil(seconds),'s'), 'hh:mm:ss') 

arpitkharkia
Creator III
Creator III
Author

Thank you for all the suggestions!

QlikBeginner
Contributor
Contributor

I have a question with regards to a similar situation:

All my time formats are in 24 hour format: 

Example 1: 234832

Example 2: 023704

I would like to convert that into 24 hour time format - do you have any suggestions? 

I have used Time(Time#(234832,'HHMMSS'), 'HH:MM:SS'), but it converts only few numbers into the right time format.

oliveira1903
Contributor III
Contributor III

Hello.

Did you manage to solve it?

I'm having this same problem. Any tips? =]

Thank you

MarcoWedel

please describe your issue in a new thread

thanks