topic group time into hours in QlikView

group time into hours

Wed, 06 Aug 2014 08:51:59 GMT

Hi, I have a variable that displays 'YYYYMMDD hh:mm', but I only need the hours so that I can display it in a chart axis. I've tried 'time(Timestamp#(fieldname,'YYYYMMDD hh:mm'),'hh:00') as newVarName' but I got

How can I group them into only 1 of each hour? Thanks.

Re: group time into hours

tresB — Wed, 06 Aug 2014 08:54:30 GMT

Try with hour(), like:

hour(Timestamp#(fieldname,'YYYYMMDD hh:mm')) as newVarName

Re: group time into hours

ashfaq_haseeb — Wed, 06 Aug 2014 09:10:33 GMT

Try

hour(fieldname) as Hour

Regards

ASHFAQ

Re: group time into hours

er_mohit — Wed, 06 Aug 2014 09:22:59 GMT

Try this

Interval(Timestamp#(fieldname,'YYYYMMDD hh:mm'),'hh') as Hour

Re: group time into hours

alok0017 — Sat, 21 Nov 2020 00:15:11 GMT

Try to apply:

=Hour(Timestamp(colomn name,'hh'))

Re: group time into hours

Wahl154169 — Wed, 25 Nov 2020 07:20:49 GMT

try this hour(fieldname) as Hour

regards

navyarmyccu