topic Re: Convert value as time in QlikView

Convert value as time

realpixel — Fri, 22 Nov 2013 07:39:57 GMT

Hello,

I have a fiel named "HMHEURCR" that I want to convert as a time.

For example value 143953 must converted to HH:MM:SS

I try an expression something like that but is not works

if(Right([HMHEURCR],2) <> 00, Time(time#([HMHEURCR],'HHMMSS'),'HH:MM:SS')) as HEURE,

Someone have an idea?

Re: Convert value as time

Jason_Michaelides — Fri, 22 Nov 2013 07:44:10 GMT

Why are you using the IF() statement first? What difference does it make if SS = 00?

Time(time#([HMHEURCR],'HHMMSS'),'HH:MM:SS') as HEURE

looks like it should work. Or the hhmmss may be case-sensitive:

Time(time#([HMHEURCR],'hhmmss'),'hh:mm:ss') as HEURE

Hope this helps,

Jason

Re: Convert value as time

Fri, 22 Nov 2013 07:50:42 GMT

Hi,

Check out the link below,

http://community.qlik.com/message/366746#366746

Hope it Helps You...

Regards,

Ravikant

Re: Convert value as time

Fri, 22 Nov 2013 07:52:11 GMT

try this

date(date#('143953','HHMMSS'),'HH:MM:SS')

OR THIS ONE

Time(Time#('143953','HHMMSS'),'HH:MM:SS')

***************************************************

similarly for field

date(date#(fieldname,'HHMMSS'),'HH:MM:SS')

OR THIS ONE

Time(Time#(fieldname,'HHMMSS'),'HH:MM:SS')

Re: Convert value as time

Fri, 22 Nov 2013 08:01:33 GMT

If you just want to convert it into time then there is no need to use if condition, you can directly use:

=Time(time#(HMHEURCR,'hhmmss'),'hh:mm:ss') as HEURE

in your expression.

Otherwise, if you really want to compare then use this:

=if(Right([Date_Num],2) <> 00, Time(time#(Date_Num,'hhmmss'),'hh:mm:ss')) as HEURE

Hope this helps!

Re: Convert value as time

Anonymous — Fri, 22 Nov 2013 08:07:12 GMT

hi ,

use

Time(time#([HMHEURCR],'HHMMSS'),'HH:MM:SS')) as HEURE

it will read current format and covert in traget format.