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

    IF in SQL SELECT statements


      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?