Defining complex filters
You can specify complex filter criteria when you create or modify an exposure view and in other areas of Touchstone.
Some filter fields do not include a list from which you can select a value—click here for a table of valid values in filter fields.
The example in this topic shows you how to create an exposure view that includes data where:
The country is the United States
AND
The state is Florida
AND
The peril is Tropical Cyclone
OR
The state is California
AND
The peril is Earthquake
AND
The contract status is Bound
Procedure
- Open a project.
-
On the Exposure Views tab, click New
.
The Create New Exposure View pane appears. - Select the databases and exposure sets that you want to include in the view.
-
Expand the Filters area (below the grid).
-
Create the filter:
-
[Optional] Select the Include all locations for multi-location
layered contracts that meet the filter criteria check
box.
If you create a filter that excludes only some locations in a particular contract, this option ensures that all other locations that do not meet the filter criteria, but that are in that contract, are included as part of the exposure view. Using this option avoids non-intuitive analyses. For example, you have a single contract with locations that span the entire East Coast of the United States. You create a filter that includes only locations in New York, and you do not select Include all locations for multi-location layered contracts. The exposure view will contain only locations in New York. For events that make multiple landfalls along the East Coast this could result in inaccurate layer losses for the contract as a whole. However, if you select this option, all additional locations that are in that contract will be included in the analysis, ensuring that the layer losses make sense. The results returned when selecting this option reflect losses to all locations in each contract affected by each event, not just the locations retrieved by the filter you applied. check box.
This can be useful if the Florida locations, in this example, come from a variety of policies and you want to be able to back-allocate policy terms and conditions. (This field does not appear in the Apply Exposure Filter dialog box on the tab.) -
Name the exposure view and then click Create or click
Apply (depending on where you are creating the
filter).
The following image shows the exposure view created by following the preceding steps.