I have a QGIS layer with information about administrative boundaries at sub-municipality level. I want to extract only land area in each sub-municipality using information from another layer. I've followed the suggestions here: How to create a new layer from overlap between two layers?.
Each row in the "administrative division" layer attribute table corresponds to one sub-municipality, and each row in the "land area" layer attribute table corresponds to one municipality (for some reason municipality data covers only land area, while sub-municipality data also includes water).
When I use the intersect tool, the created new layer only covers some parts of the layer (i.e., some municipalities, as displayed in picture below*). The pink/purple part is exactly the result I want, but I want it for the entire layer. What is the problem? I've ensured that all rows are selected in both layers.
This is my first time working with GIS-data, so forgive me if it's a stupid question.
**Data privacy note: I've edited the picture so these are not the true administrative boundaries.*