Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

group time into hours

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

Untitled8.png

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

5 Replies
tresesco
MVP
MVP

Try with hour(), like:

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

ashfaq_haseeb
Champion III
Champion III

Hi

Try

hour(fieldname) as Hour

Regards

ASHFAQ

er_mohit
Master II
Master II

Try this

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

alok0017
Contributor
Contributor

Try to apply:

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

Wahl154169
Contributor
Contributor

try this hour(fieldname) as Hour

regards

navyarmyccu