Discussion board where members can learn more about Qlik Sense Data Connectivity.
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
However, no matter how I fiddle with it, the script throws an error. What am I doing wrong?
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!