Apply a filter
In this topic
In Esri Maps for IBM Cognos, you can apply filters to layers in the map to present a focused view of your data. By limiting the visibility of features in a layer, patterns can more easily be revealed. For example, a filter might be applied to a layer showing retailer locations so that only the retailers with a yearly revenue of at least $15,000 are displayed on the map.
When configuring a map, the report author has the option of applying filters to specific layers. Report consumers can modify these filters or create their own to change the view of the map. Report authors also have the option of disabling the Filter layer tool in a report. For more information, see Configure map settings and tools.
Modify or create a filter
You can apply a filter to layers added from IBM Cognos, feature service layers, or dynamic map service layers from ArcGIS.
- In the Contents pane, click the Configure layer button
beside the layer for which you want to modify or create a filter. - Choose Filter layer.
Note:
This tool is only available if it was enabled by the report author.
- Modify or create a new filter expression.
Note:
Expressions use the general form of <Field_name> <Operator> <Value, Field, or Unique>.
- You can create one expression, multiple expressions (click Add another expression), or one or more sets of expressions (click Add a set). A set is a grouping of expressions, for example, Retailer_type = department_store and Revenue <= 10,000.
- If you have more than one expression, use AND or OR to display features in the layer that match all or any of your expressions. AND requires that all of the criteria you have specified must be true. OR means that any of your expressions must be true for the features to display.
- For the field part of the expression, choose the field you want to query against from the drop-down menu with fields.
- For the operator part of the expression, choose an operator from the drop-down menu with operators, such as =, <>, >=, or <.
- If you want to filter based on a specific value, choose Value and enter a value in the field. The input box varies depending on the field type.
- If you want to compare the value in one field to the value in another field, choose Field and choose the field for your expression from the drop-down menu.
- If you want to filter based on a specific value in the field you've chosen for your expression, choose Unique and choose a unique value from your field. Unique value filters require an ArcGIS 10.1 or later map service. The Unique option does not appear if you are creating a filter on an ArcGIS 10.0 or earlier service.
- To delete an expression or set in the filter, click the Delete button to the right of your expression or set.
- To add an expression to a set, click the Add an expression to this set button to the lower right of the set.
- When you are finished modifying or creating your filter expression, click Apply to apply the filter to the layer.
The map updates to display the new filtered view.
Note:
You can click Reset at any time to remove the filter from the layer.
- Click the Close button to close the Filter tool.
Considerations for filters
- Do not add special characters to your values unless those special characters are part of the value. For example, City = "New York" doesn't find a feature named New York. In this example, use City = New York instead.
- If your field includes coded values, the Values list shows all coded values defined by the service for the field. This may include values that do not exist as features in the layer. The Unique list shows all the features in the layer (which may be a subset of the values in the service).
- The Unique option requires an ArcGIS 10.1 or later map service. The option does not appear if you are filtering an ArcGIS 10.0 or earlier map service.
- If you have multiple expressions, your results vary depending on how and whether you group them in sets. For example, if you create a filter where all of the following expressions must be true: Investment_class = Balanced Fund OR Investment_class = Mortgage Fund (this is a set) AND Client_sales is >= 30,000 (this is a single expression), the filter selects Balanced Fund investment branches and Mortgage Fund investment branches with client sales greater than or equal to $30,000.
If you instead create your filter where the following must be true: Investment_class = Balanced Fund AND Client_sales >= 30,000 (now this is your set) OR Investment_class = Mortgage Fund (this is a single expression), your filter selects Balanced Fund investment branches with client sales greater than or equal to $30,000 and all Mortgage Fund investment branches.