topic Re: tima format in QlikView

tima format

Anonymous — Tue, 18 Feb 2014 05:56:17 GMT

hi,

i have feild like this -141819 (hhmmss)

i want to make it to time like this:

14:18

how can i do it ?

thanks'

yarin.

jonathandienst — Tue, 18 Feb 2014 06:01:02 GMT

This should do it. Expression:

=Time(Time#(myField, 'HHMMSS'), 'HH:MM')

or script:

Time(Time#(myField, 'HHMMSS'), 'HH:MM') As myField,

HTH

Jonathan

kumarnatarajan — Tue, 18 Feb 2014 06:02:10 GMT

Hi,

Try below one.

Ex: Time(Time#(141819,'hhmmss'),'hh:mm')

MayilVahanan — Tue, 18 Feb 2014 06:04:45 GMT

Try like this

TIme(Time#(fabs(-141819),'hhmmss'),'hh:mm')

TIme(Time#(141819,'hhmmss'),'hh:mm')

sunilkumarqv — Tue, 18 Feb 2014 06:08:48 GMT

Set TimeFormat='hh:mm:ss';

you want to change the regional settings in OS

Tue, 18 Feb 2014 06:42:24 GMT

hi yarin

=Time(Time#(FieldofTime, 'hhmmss'), 'hh:ss')