topic Round up timestamp in QlikView

Round up timestamp

Mon, 14 Jan 2013 14:41:24 GMT

Hello,

I have a field with timestamps, e.g. 20/12/2012 18:32:30 etc and if I use the hour function the previous example would give me 18. However for the purposes of my report I need to round this up so that it would be 19. So essentially anything that happens between 18:00:00 and 18:59:59 should have an hour value of 19 and not 18. Does anyone have a solution to this?

Thanks,

Ralph

Re: Round up timestamp

CELAMBARASAN — Mon, 14 Jan 2013 14:47:57 GMT

Check with this expression

=Ceil(Hour(TimestampField)&'.'&Minute(TimestampField)&Second(TimestampField))

Hope it helps

Celambarasan

Re: Round up timestamp

Mon, 14 Jan 2013 15:07:47 GMT

Thanks for that