Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
rmnvncnt
New Contributor

Equivalent of DayStart for Hours?

I'm trying to reproduce the result of DayStart() in the backend but at the hour level. My input data consists in 'DD/MM/YYYY hh:mm:ss' timestamps.

I tried this :

Timestamp(Floor(($(vTransactionDateTime) * 24) / 24))

but it returns rounded up data to the day level.

Any idea?

Tags (1)
1 Solution

Accepted Solutions

Re: Equivalent of DayStart for Hours?

Try this

Timestamp(Floor($(vTransactionDateTime), 1/24))

View solution in original post

1 Reply

Re: Equivalent of DayStart for Hours?

Try this

Timestamp(Floor($(vTransactionDateTime), 1/24))

View solution in original post