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