Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

round down time to hours

Hi, how can I round down time 'hh:mm' to hours? eg. 07:55 will round down to '07:00'

Thanks.

1 Solution

Accepted Solutions
peterwh
Contributor

Re: round down time to hours

Hi,

I don't know, if there's a simplier solution, but "maketime(hour(<TimeField>))" should do the trick. If you only set the format, the value stays at 07:55, it's only displayed as 07:00.

Kind regards

Peter

2 Replies
peterwh
Contributor

Re: round down time to hours

Hi,

I don't know, if there's a simplier solution, but "maketime(hour(<TimeField>))" should do the trick. If you only set the format, the value stays at 07:55, it's only displayed as 07:00.

Kind regards

Peter

Re: round down time to hours

Hi,

Try below

=hour(ceil(time#('07:55','hh:mm'),1/24))

Regards

ASHFAQ