Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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.