Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

IF in SQL SELECT statements

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

Tags (1)
1 Reply
Not applicable

Re: IF in SQL SELECT statements

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!

Community Browser