Re: where clause need to be replaced in qlik - Qlik Community

aniruddhyadutta · ‎2017-01-13

Hi All,

I hdo have an oracle sql where its using a particular condition in where clause which I need to do in qlik

which is something like this below

2359 - (30 - to_number(to_char(SYSDATE, 'HH24MI'))) < to_number(schedule_time)

can anyone help me to understand this and convert it to qlik equivalent.

cheers!

AD

girirajsinh · ‎2017-01-14

Hi Aniruddhya

You may try something like below in where clause of load

2359-(30-num#(hour(now()))<num#(field)

check our more date time related functions and formats here

Let me know how it goes.