Using ELSEIF in QGIS Field Calculator

Question

I found a similar question, but the answer solve the problem indirectly. So, here I reshape the question.

Say, in the following situation, how am I going to use "ELSE IF" statement?

CASE
  WHEN  "land use" != 'residential' THEN 'other land uses'
  ELSEIF  "area" < 1000 THEN 'small lot'
  ELSE 'large lot'
END

Taras · Accepted Answer · 2020-06-23T06:09:49.140

6

For your issue I can suggest trying this query

CASE
  WHEN  "land use" != 'residential' THEN 'other land uses'
  WHEN  "area" < 1000 THEN 'small lot'
  ELSE 'large lot'
END

Moreover, I recommend reading this article W3Schools | SQL CASE Statement and paying attention to CASE Syntax.

To comprehend the difference between quotation marks in QGIS please read this thread Difference between quotation marks ('single' vs “double”) in QGIS.

edited Jun 23 '20 at 06:09

answered Jun 23 '20 at 05:49

Taras

I read that tutorial and it seems that the when in the case statement is like the elseif in a if-elseif-else statement. Is that correct? – David H. J. Jul 01 '20 at 04:03
1

More like IF and at the same time ELIF – Taras Jul 01 '20 at 04:42

1 Answers1