1 Reply Latest reply: Jan 14, 2017 12:10 PM by Girirajsinh Vaghela RSS

    where clause need to be replaced in qlik

    Aniruddhya Dutta

      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