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
Highlighted
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!