Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

what do i do I want the time to show every 4 hours.

I want Time_Dateout time to display every 4h starting from 06:00:00 Am.

Paknanarn23_0-1675930824862.png

 

Labels (4)
3 Replies
marcus_sommer

Maybe with: time(floor(YourTimeField, 4/24)) 

Paknanarn23
Creator II
Creator II
Author

The data is showing every 4h already, but I still want it to start from 06:00:00 AM because now you gave me the data to start from 4:00:00 AM

Paknanarn23_0-1675992952327.png

 

marcus_sommer

Maybe with: time(floor(YourTimeField, 4/24) + maketime(2))

Further it might be more suitable to make such categorizing within the data-model within the master timetable.