For a shape-file , which contains only two fields id and name of the political districts I created a new field "Bundesland" (federale State) with the following expression:
CASE WHEN id< 200 THEN 'Burgenland'
WHEN id >= 200 AND id < 300 THEN 'Kärnten'
WHEN id >= 300 AND id < 400 THEN 'Niederösterreich'
WHEN id >= 400 AND id < 500 THEN 'Oberösterreich'
WHEN id >= 500 AND id < 600 THEN 'Salzburg'
WHEN id >= 600 AND id < 700 THEN 'Steiermark'
WHEN id >= 700 AND id < 800 THEN 'Tirol'
WHEN id >= 800 AND id < 900 THEN 'Vorarlberg'
ELSE 'Wien'
END
This works fine so far and now a new field "Bundesland" can be used as Identifier. When I used this new field for Aggregation, this field appears serveral times in the selection list:
Note: This is only a "cosmetical problem" as the aggregation works as expected
Updated: When I export the shape-file under a new name and use it again, the cosmetic problem disappears
For a shape-file , which contains only two fields id and name of the political districts I created a new field "Bundesland" (federale State) with the following expression:
CASE WHEN id< 200 THEN 'Burgenland'
WHEN id >= 200 AND id < 300 THEN 'Kärnten'
WHEN id >= 300 AND id < 400 THEN 'Niederösterreich'
WHEN id >= 400 AND id < 500 THEN 'Oberösterreich'
WHEN id >= 500 AND id < 600 THEN 'Salzburg'
WHEN id >= 600 AND id < 700 THEN 'Steiermark'
WHEN id >= 700 AND id < 800 THEN 'Tirol'
WHEN id >= 800 AND id < 900 THEN 'Vorarlberg'
ELSE 'Wien'
END
This works fine so far and now a new field "Bundesland" can be used as Identifier. When I used this new field for Aggregation, this field appears serveral times in the selection list:
Note: This is only a "cosmetical problem" as the aggregation works as expected
Updated: When I export the shape-file under a new name and use it again, the cosmetic problem disappears