Discussion board where members can learn more about Qlik Sense App Development and Usage.
Good day Qlickers.
As you know, Dates are a headache in Qlik Sense. I always have a hard time around them.
How do I get a timestamp to hourly buckets?
Ive tried some stuff already but I cant seem to get it to work.
See the table attached:
I want to create Hourly buckets on that Timestamp if possible. My times are in 24hours.
This is my script:
Hope someone can help me.
Use Trunc(yourdatetimefield,1/24) to convert to lowest hour
In meantime "Dates are NOT a headache in Qlik Sense." 🙂 🙂
This trunc is not recognized in my script?
I tried this and it works if I do a limited load thru the debugger. It returns exactly what I want.
Output: See Time and Bucket columns. It works.
Problem is, when I reload the entire App, the Time and Bucket Fields return Blank. What causes this?
Hope you can help me
I´m so sorry, my mistake
Use Floor(yourdatetimefield,1/24) to convert to the lowest hour