topic Re: Time within 24 hours in QlikView

Time within 24 hours

richard_chilvers — Tue, 30 Dec 2014 11:41:06 GMT

Does anyone have any neat ways of dealing with data within a 24 hour time-frame?

My data is date/time stamped, and I would like to select the data for activity exactly within 24 hours of the reload date/time. This will of course overlap midnight.

This needs to be at chart expression level and I would be happy to deal in hours, rather than down to minutes/seconds.

I have a few ideas but they all seem rather clumsy, so any suggestions are welcome.

Thanks

Re: Time within 24 hours

Tue, 30 Dec 2014 13:40:26 GMT

Hi Richard,

use Now() for current timestamp, subtract your input timestamp (given it's a correct format) when the difference is <= 1 than within the last 24 hours.

Do your further processing in order to shape your Data model.

good luck

cheers

Re: Time within 24 hours

richard_chilvers — Tue, 30 Dec 2014 13:47:42 GMT

Thanks Felix

The solutions I was trying were far to complicated and this is nice and simple. I'm assuming that if I want a 72 hour interval, I use <=3 instead?

Re: Time within 24 hours

Tue, 30 Dec 2014 13:53:01 GMT

yw, yep 1 is 24 = one day. The fractal is the part of the day which can easily put into hours etc...

good luck!