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!
Retrieving data ...