1 Reply Latest reply: Oct 15, 2016 12:15 PM by Steven Edge RSS

    IF in SQL SELECT statements

    Steven Edge

      Hi,

      Just new to Qlik. I need to put in some conditional selection in my SQL, such as

       

      SQL SELECT IF(field_a = ' ', field_b, field_a) AS myfield

           FROM mytable

      However, no matter how I fiddle with it, the script throws an error. What am I doing wrong?

       

      Steven