I am using QGIS 2.18.11 and I have a shape layer with lines and polylines I need to review; but not all of them, only certain ones. The ones I need to review are marked in a specific field (rev = 0 or rev = 1) in an Excel file (.xlxs). Both data files share the same ID, so I could connect them.
How I would normally do this is performing a join in my shapefile with the Excel file using the ID; then I would add a new field in the shapefile and update it with the "rev" field data; I would then close the excel file so I can keep on working on it in parallel; finally I would filter my shapefile with "rev"=1, and there I have the lines and polylines I need to review.
Is there a faster way? Also a way that does not make me edit the shapefile (by creating that "rev" field)?