QGIS 3.2.3: I have a shapefile and an Excel table which is joined to the shapefile based on matching IDs.
I would like to filter the shapefile while using a joined field from the Excel table.
When I select "Filter" at the shapefile, I get the message that filter on joined tables is only possible when creating a "Virtual Layer". I click "Yes" when asked if I want to create a virtual layer.
Nevertheless, when the query builder appears, the joined fields do not appear. Did the creation of the "virtual layer" not work?
Is this not possible or am I doing something wrong?
I have found this older article: is this still valid that it is not possible in QGIS? How do you filter a layer on a joined table in QGIS?
This works in ArcGIS using a "definition query" on a joined layer.