Skip to main content

How to use Advanced Filtering in SimaPro desktop?

Advanced Filtering helps you find processes with conditions on more than one column, for example, the name, the unit, and the library. Instead of relying on exact name matches, you can apply custom, condition-based filters and locate the exact data you need. This feature is available in SimaPro 11.0 and later, for all license plans.

This article provides step-by-step instructions on how to use this feature. We will use an example to demonstrate how to find electricity processes for a specific country. For additional tips on searching for data in SimaPro, please refer to this article.

Step 1: Switch on Advanced Filtering

  1. Open your project and select Processes in the left panel.

  2. Select Show as list on the right side, to search in all categories at the same time.

  3. Tick Advanced Filtering. A grey filter bar shows above the list with the text "<Filter is Empty>".

  4. Click Customize... on the right side of the filter bar. The Filter builder opens.

Step 2: Add conditions

  1. In the Filter builder, click press the button to add a new condition. A new row shows: column, operator and value.

  2. Click the column (for example Name) to select a different column, such as Unit, Project or Category.

  3. Click the operator (for example Contains) and select the operator that you need from the list.

  4. Click <empty> and type the value, for example electricity.

  5. Add more conditions in the same way. With And, a process must agree with all conditions. Click And to change it to Or if one condition is sufficient.

Filter builder with the list of operators open

Below is the list of available operators along with the results each operator returns:

Operator

Shows the processes where the column...

Contains / Does not contain

has (or does not have) the text anywhere. This is the most useful operator for names.

Begins with / Ends with

starts or ends with the text.

Is any of / Is none of

is (or is not) one of a list of values, for example the units kWh and MJ.

Is between / Is not between

is (or is not) between two values.

Is blank / Is not blank

is empty (or is not empty).

Is like / Is not like

agrees (or does not agree) with a pattern.

Step 3: Apply the filter

  1. Click Apply to see the result and keep the Filter builder open, or click OK to apply the filter and close the Filter builder.

  2. The filter bar shows the active filter, for example, "(Name Contains electricity) And (Name Contains {CR}) And (Name Does not contain import)". Use the checkbox in the filter bar to switch the filter off and on, and the X to remove it.

  3. To go back to the standard view, untick Advanced Filtering.

The conditions: the name contains "electricity" and "{CR}", and does not contain "import".

Filter builder with three conditions

The result: electricity processes for Costa Rica, without imports. The filter bar shows the active filter.

Step 4: Save a filter to use it again

  1. In the Filter builder, click Save As... to save the filter as a file.

  2. Click Open... to use a saved filter again, also in a different project.

Good to know

  • Advanced Filtering is context-dependent. The Filter builder can show columns that are not in the current list. Use the columns that you see in the list.

  • If you go to another section and come back, the filter bar can be gone while the checkbox is still ticked. Untick Advanced Filtering and tick it again.

Did this answer your question?