topic Re: Convert seconds to time format in QlikView

Convert seconds to time format

Thu, 14 Apr 2016 06:22:38 GMT

Hi,

I have calculated field in script as Second and now I want to convert it to time format.

for eg. 5326 to 01:28:46

Re: Convert seconds to time format

Chanty4u — Thu, 14 Apr 2016 06:24:46 GMT

hi,

try lik dis

Interval(TIME_SECONDS/86400, 'hh:mm:ss') as TIME_1

Re: Convert seconds to time format

Chanty4u — Thu, 14 Apr 2016 06:25:00 GMT

ref

Rounding Errors

Re: Convert seconds to time format

Kushal_Chawda — Thu, 14 Apr 2016 06:25:36 GMT

see this

Time Difference or Time in Human Readable Format

Re: Convert seconds to time format

tamilarasu — Thu, 14 Apr 2016 06:25:46 GMT

Try,

Expression:

=Timestamp(FieldName/86400 ,'hh:mm:ss')

Script:

Timestamp(FieldName/86400 ,'hh:mm:ss') as Time

Re: Convert seconds to time format

Chanty4u — Thu, 14 Apr 2016 06:25:59 GMT

or else

time(YourField/3600/24, 'hh:mm:ss') as YourFiled

Sample attached

Re: Convert seconds to time format

Thu, 14 Apr 2016 06:30:22 GMT

U can the time funcion

=time('field'/3600,'hh:mm')

Re: Convert seconds to time format

HirisH_V7 — Thu, 14 Apr 2016 06:35:50 GMT

Hi,

May be like this,

Data:
LOAD * ,
Time(Time#(Field,'ss'),'hh:mm:ss') as Time
INLINE [
Field
5326
];

Output:

In Text Box:

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

HTH,

PFA,

Hirish

Re: Convert seconds to time format

Thu, 14 Apr 2016 06:39:08 GMT

Try,

Expression:

=Timestamp(FieldName/86400 ,'hh:mm:ss')

Script:

Timestamp(FieldName/86400 ,'hh:mm:ss') as Time