topic Re: time format in QlikView

time format

Anonymous — Tue, 30 Jul 2013 08:40:37 GMT

hi,

i have feild that present time like this:

1138

625 ( means 06:25)

1758 ( means 17:58)

how i chenge to format HH:MM

and i need that 625 will bt 06:25 , or 12 will be 00:00

thanks'

yarin.

Re: time format

Tue, 30 Jul 2013 08:45:57 GMT

time(time#('625','hmm'),'hh:mm')

Re: time format

Tue, 30 Jul 2013 08:47:25 GMT

try this

time(Time#(field,'hhmm'),'hh:mm')

or try this

Date(Date#(field,'hhmm'),'hh:mm')

Re: time format

ariel_klien — Tue, 30 Jul 2013 11:24:26 GMT

if you have 2 options in the filed (625,1758) you need to combine the 2

try this:

if(len(Field_Name)=3,TIME#(Field_Name,'hmm'),TIME#(Field_Name,'hhmm'))

Ariel

Re: time format

jagan — Tue, 30 Jul 2013 11:39:29 GMT

Hi,

Use Alt() for handling multiple date formats in a single field

=Alt(time(time#('TimeDimension','hhmm'),'hh:mm'), time(time#('TimeDimension','hmm'),'hh:mm'), time(time#('TimeDimension','hhmm'),'hh:mm'),time(time#('TimeDimension','hh'),'hh:mm'))

Hope this helps you.

Regards,

Jagan.