topic Re: Problem with if statement in QlikView

Re: Problem with if statement

Lisa_P — Mon, 26 Jan 2026 18:19:17 GMT

The problem is that even thought he presentation is an integer, this is still a timestamp, so if you add the hour function, you convert it to an integer..

=if(hour <= hour(Date(Now(),'hh')), hour, NULL())

Re: Problem with if statement

bsocks_11415 — Fri, 20 Aug 2021 12:56:45 GMT

Yes, that did it! I had tried using =if(hour <= Num(Date(Now(),'hh')), hour, NULL()) to convert it to a integer but wasn't getting any useful results. Didn't think to convert using hour(). Thank you!

Re: Problem with if statement

MayilVahanan — Sat, 21 Aug 2021 02:27:23 GMT

FYI: Simply, you can use hour function instead of hour(Date(Now(),'hh'))

=hour(Now())