topic Re: Text Conversion to HH:MM:SS in QlikView

Text Conversion to HH:MM:SS

richard_sweet — Thu, 20 Sep 2018 15:27:57 GMT

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?

Re: Text Conversion to HH:MM:SS

jonathandienst — Thu, 20 Sep 2018 15:32:39 GMT

Yes:

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

Re: Text Conversion to HH:MM:SS

Anil_Babu_Samineni — Thu, 20 Sep 2018 15:32:42 GMT

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

Re: Text Conversion to HH:MM:SS

richard_sweet — Thu, 20 Sep 2018 15:41:17 GMT

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.

Re: Text Conversion to HH:MM:SS

vishsaggi — Thu, 20 Sep 2018 16:01:19 GMT

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

Re: Text Conversion to HH:MM:SS

richard_sweet — Thu, 20 Sep 2018 16:13:38 GMT

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.