14

I am trying to write an ELSEIF conditional statement in QGIS Field Calculator (version 1.8.0). I have used an example I found online:

CASE WHEN val < 0 THEN 'negative'
  WHEN val = 0 THEN "neutral'
  ELSE 'positive'
END

I modified the statement as follows:

CASE WHEN  "GRID_ID"  = 1 THEN 'complete'
  ELSEIF  "GRID_ID"  = 2 THEN "in progress'
  ELSE 'not started'
END

This statement would not run, the Output preview stated Expression is invalid. The more info stated: Parser Error: syntax error, unexpected COLUMN_REF, expecting WHEN or ELSE or END

If anyone has had this error, what did you do to fix it?

21

You have a few problems in your modified statement.

  • Inconsistent use of quotes around "in progress'
  • You don't need quotes around column names.
  • You're using an "ELSEIF" when it should be a "WHEN".

The following should resolve all three issues and works for me in 1.8.0:

CASE WHEN GRID_ID = 1 THEN 'complete'
  WHEN GRID_ID = 2 THEN 'in progress'
  ELSE 'not started'
END
  • 2
    "You don't need quotes around column names." You don't but I would still recommend it as it will help the syntax highlighter mark that part as a column. – Nathan W Nov 3 '12 at 1:20
  • @NathanW - the Syntax highlighter marks column names in red whether you use quotes or not, at least it does in my 1.8.0 install. – GIS-Jonathan Nov 5 '12 at 12:23
  • 1
    It does indeed. That is pretty embarrassing, I should have known it does that as I wrote the highlighter ;) – Nathan W Nov 5 '12 at 13:17
  • @NathanW - Understandable. I can barely remember what I wrote yesterday after all. ;-) – GIS-Jonathan Nov 5 '12 at 14:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.