topic Re: Expression: Convert seconds to HH:MM:SS in QlikView

Expression: Convert seconds to HH:MM:SS

Thu, 20 Feb 2014 09:39:32 GMT

Hello!

I have a problem, i import a table from SQL via ODBC, where there is a count in Seconds.

If i choose a date, i can make a statistics box to see the avg. but i seconds.

I want to see these numbers in HH:MM:SS.

Lets say i want to make a diagram showing the different times, how can i write an expression that convert to HH:MM:SS?

Thanks!

Re: Expression: Convert seconds to HH:MM:SS

Thu, 20 Feb 2014 09:46:15 GMT

try this

Time(Time#(fieldname,'ss'),'hh:mm:ss')

Re: Expression: Convert seconds to HH:MM:SS

Thu, 20 Feb 2014 09:51:17 GMT

hi try like this

=Time(Time#('4550','ss'),'hh:mm:ss')

then output like this

01:15:50

Re: Expression: Convert seconds to HH:MM:SS

er_mohit — Thu, 20 Feb 2014 10:05:56 GMT

use interval function

Re: Expression: Convert seconds to HH:MM:SS

Thu, 20 Feb 2014 11:13:31 GMT

I get "No Data to display"

Re: Expression: Convert seconds to HH:MM:SS

Thu, 20 Feb 2014 11:39:26 GMT

Please tell me how

Re: Expression: Convert seconds to HH:MM:SS

amit_saini — Thu, 20 Feb 2014 11:42:56 GMT

Hi Erik,

Go to chart properties-->go to number tab and select desired format you want.

Thanks,

Re: Expression: Convert seconds to HH:MM:SS

Thu, 20 Feb 2014 11:47:14 GMT

No sorry that does not help.

I have a list with seconds.

And i want to express them like HH:MM:SS

Re: Expression: Convert seconds to HH:MM:SS

amit_saini — Thu, 20 Feb 2014 11:50:34 GMT

Hi Erik,

This can be possible while selecting timestamp option the the properties you define your format hh:mm:ss

and you will get the correct result.

Thanks,

Re: Expression: Convert seconds to HH:MM:SS

amit_saini — Thu, 20 Feb 2014 11:56:22 GMT

Hi Erik,

You can also you this script:

dual( Date(TS,'YYYY-MM-DD') &'T' & time(TS,'hh:mm:ss'), num(TS) ) as Timestamp,

Thanks,