Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

TIME VALUE NULL

Hi Community,

the source data has a value like  "83459 " which really should be 083459 and I should represent as 8:34:59. How to accomplish that?

The field is ClosedTime

3 Replies
MVP
MVP

Re: TIME VALUE NULL

Load

  Num(ClosedTime,'000000') as ClosedTimeNum,

  Time(Time#(Num(ClosedTime,'000000'),'hhmmss'),'hh:mm:ss') as ClosedTime

Inline

[

  ClosedTime

  83459

];

prat1507
Valued Contributor

Re: TIME VALUE NULL

Hi Fabio

Use the below exp:

=MakeTime(right((83459-right(83459,4))/10000,2),

right((83459-right(83459,2))/100,2),

right(83459,2))

You can variablize or use a field instead.

Regards

Pratyush

shraddha_g
Honored Contributor III

Re: TIME VALUE NULL

Try

time(Time#(num(Field),'hhmmss'),'hh:mmSmiley Frustrateds')

Community Browser