In an elevation file I want to find all the 5m contours and mark a column up as major. This has to be done in QGIS in the field calculator or modeler.
I want to do something like the following based on this post
CASE WHEN "elevation" %% 5 THEN 'major'
WHEN "elevation" %% 1 THEN "moderate"
ELSE "Minor"
END
But this doesn't work -
Parser Error: syntax error, unexpected MOD
Eval Error: No root node! Parsing failed?
Ideally I want to run it as part of the following (which works but level 50 includes 1m and 5m contours)
CASE WHEN "contour_level" = 48 THEN 'minor'
WHEN "contour_level" = 49 THEN 'minor'
WHEN "contour_level" = 50 THEN 'moderate'
ELSE 'Check'
END
%
rather than%%
.