topic Re: Time Format in QlikView

Time Format

Wed, 25 Nov 2020 16:16:04 GMT

Hello guys! I have a question that must been very dumb but I can´t find the solution :(. I have in a column numbers as 312.5, 350.4 …which represent hours and mins.

I would like to have these numbers in the following format 312.5 as 312:50:00, 350.4 as 350:40:00..

Anny idea?

Thank you!!

Re: Time Format

Chanty4u — Thu, 11 Aug 2016 09:36:01 GMT

try this

stampp:

LOAD * INLINE [

date

312.5

350.4

];

Result:

LOAD *,

Timestamp(Timestamp#(date,'hhh.m'),'hh:mm:ss') as new

Resident stampp;

Re: Time Format

puttemans — Thu, 11 Aug 2016 10:12:51 GMT

Hi,

If your values are correct, then try

subfield( time, '.', 1)&':'&(subfield(time, '.',2)*10)&':00' as newtime

where 'time' is the name of your original value, and newtime the new variable.

Regards,

Johan

Re: Time Format

sunny_talwar — Thu, 11 Aug 2016 10:36:18 GMT

May be this:

Table:

LOAD *,

Interval(Interval#(Floor(Time), 'h') + Interval#(Round(Frac(Time) * 100), 'mm'), 'h:mm:ss') as New_Time;

LOAD * Inline [

Time

312.5

350.4

];

Re: Time Format

Fri, 12 Aug 2016 07:02:09 GMT

Thank You very much Sunny T.

It worked perfectly!!