Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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