topic Re: Remove Seconds from hh:mm:ss in QlikView

Remove Seconds from hh:mm:ss

prees959 — Fri, 09 Mar 2018 09:10:34 GMT

Hi,

I am importing data from a csv file which has some time fields eg

08:00:00

Is there a simple way to remove the ss portion of the time field ?

Many thanks,

Phil

Chanty4u — Fri, 09 Mar 2018 09:14:20 GMT

try this

Time#(Text(Time(Frac(UrFiled), 'hh:mm:ss')), 'hh:mm') as END_TM

YoussefBelloum — Fri, 09 Mar 2018 09:14:56 GMT

Hi,

try this:

=Time(Time#(Field,'hh:mm:ss'),'hh:mm')

chinnuchinni — Fri, 09 Mar 2018 09:21:15 GMT

You can use below script:

Time(fieldname,'hh:mm')

prees959 — Fri, 09 Mar 2018 10:26:25 GMT

Hi, thanks for your replies - unfortunately after trying each solution I am still getting hh:mm:ss

YoussefBelloum — Fri, 09 Mar 2018 10:32:23 GMT

So try to attach some line on an excel file from your original column

tresB — Fri, 09 Mar 2018 10:39:08 GMT

Try first truncating the seconds from your timestamps first using floor() and then format it using time(), like:

=time(floor(timeField, 1/24/60),'hh:mm')

prees959 — Fri, 09 Mar 2018 11:39:26 GMT

thank you !

Anonymous — Fri, 06 Jul 2018 13:50:01 GMT

here we go:

time#(text(time(floor(TIMESTAMP, 1/24/60),'hh:mm')),'hh:mm') as Time

this will create 1440 unique values, for the time field hh:mm, the numerical value will have no ss in it.

sunny regards