topic IF in SQL SELECT statements in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/IF-in-SQL-SELECT-statements/m-p/1198924#M2192 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Just new to Qlik. I need to put in some conditional selection in my SQL, such as</P><P></P><P>SQL SELECT IF(field_a = ' ', field_b, field_a) AS myfield</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FROM mytable</P><P>However, no matter how I fiddle with it, the script throws an error. What am I doing wrong?</P><P></P><P>Steven</P></BODY></HTML> Sat, 15 Oct 2016 14:20:45 GMT 2016-10-15T14:20:45Z IF in SQL SELECT statements https://community.qlik.com/t5/Connectivity-Data-Prep/IF-in-SQL-SELECT-statements/m-p/1198924#M2192 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Just new to Qlik. I need to put in some conditional selection in my SQL, such as</P><P></P><P>SQL SELECT IF(field_a = ' ', field_b, field_a) AS myfield</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FROM mytable</P><P>However, no matter how I fiddle with it, the script throws an error. What am I doing wrong?</P><P></P><P>Steven</P></BODY></HTML> Sat, 15 Oct 2016 14:20:45 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/IF-in-SQL-SELECT-statements/m-p/1198924#M2192 2016-10-15T14:20:45Z Re: IF in SQL SELECT statements https://community.qlik.com/t5/Connectivity-Data-Prep/IF-in-SQL-SELECT-statements/m-p/1198925#M2193 <HTML><HEAD></HEAD><BODY><P>I think I figuredit out myself. I was working on the assumption that I needed to use Qlik syntax or standard SQL syntax, when in fact it turns out that one uses the native syntax of the database source that is being queried!</P></BODY></HTML> Sat, 15 Oct 2016 16:15:14 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/IF-in-SQL-SELECT-statements/m-p/1198925#M2193 2016-10-15T16:15:14Z