I have a shape with different city areas that contains the average building heights ("HHO-mean"
) in meters. Now I want to categorize the average building heights in a new column in five different categories (1-5).
I tried the following:
CASE
WHEN "HHO_mean" > 5.7 THEN 1
WHEN "HHO_mean" > 6.4 THEN 2
WHEN "HHO_mean" > 7.1 THEN 3
WHEN "HHO_mean" > 8.0 THEN 4
WHEN "HHO_mean" > 10 THEN 5
END
and
if( "HHO_mean" > 5.7, '1', if( "HHO_mean" < 6.4, '2', if( "HHO_mean" < 7.1, '3', if( "HHO_mean" < 8.0, '4', if( "HHO_mean" < 10, '5', '0')))))
In both cases the new column only contains 1 in every field. Any suggestions?
if ("column" > 5.7 AND "column" <= 6.4)
.