Solved: Re: Text Conversion to HH:MM:SS - Qlik Community

richard_sweet · ‎2018-09-20

I have a field in my data load "Connected Duration" in format HH:MM:SS however it is being loaded as text. I have tried using interval however it loads the format as seconds only. Is there a method that can be used to load in script as numerical HH:MM:SS?

jonathandienst · ‎2018-09-20

Yes:

Time#([Connected Duration], 'hh:mm:ss')

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

View solution in original post

jonathandienst · ‎2018-09-20

Yes:

Time#([Connected Duration], 'hh:mm:ss')

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

Anil_Babu_Samineni · ‎2018-09-20

You already having same format while connection. After that how Seconds only returns? Can you confirm one more time?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

richard_sweet · ‎2018-09-20

Anil

The connection load as text initially and then when I reloaded with application of interval([Connected Duration], 'HH:MM:SS') is when it returned as only seconds.

vishsaggi · ‎2018-09-20

Did you try what jonathan suggested? Can you also share the text value of your field how it is coming?

richard_sweet · ‎2018-09-20

Jonathan,

Thanks for the helped that worked to get the format right, this will help greatly as I start to work on the calculation for averages.