Integrate a Value Set with an Advanced Condition

You can integrate a value set with an existing advanced condition through these set operators:

• INTERSECT
• MINUS
• UNION

If required, you can integrate the value set with multiple advanced conditions that can have Boolean or set operations between them.

Note:

Only those value sets that have the Advanced Condition element can be integrated with advanced conditions. All value sets that you create for predefined filters contain the Advanced Condition element. If you want to convert a custom filter value set to an advanced condition, make sure you select the Advanced Condition element when creating the custom filter.

To integrate a value set with an existing advanced conditions:

1. Create a new value set by either using predefined filters or creating custom filters.

   Alternatively, from the FILTER LIBRARY page, open a saved value set (see Work with Saved Filters and Value Sets).

   If you create a custom value set, make sure you include the Advanced Condition element.

2. Verify the field values specified for the value set.
3. On the FILTER VALUE SET page, scroll to the Advanced Condition section.
4. To enter the operator to use to integrate the value set and the advanced condition, use the Operator field.

   You may select INTERSECT, MINUS, or UNION.

5. Select the advanced condition to integrate with the value set as follows:
   1. Click the Add Advanced Condition Above icon on the left bar.

      The Advanced Conditions menu lists the advanced conditions that are stored in the system and available to you. The conditions are organized by categories.

   2. Browse to a category and select the required advanced condition.

      The selection is added as a row in the Advanced Conditions Editor

   3. Click the Add Advanced Condition Above icon or the Add Advanced Condition Below icon to insert another advanced condition above or below the existing advanced condition.

      Tip:

      To change the structure of the query by reordering of the rows, select a row and click the arrow icons to move the row up or down.
6. Type parentheses in the ( and ) columns to determine the order of execution for the selected advanced conditions.
7. To specify the set operation to perform between the selected advanced conditions, use the field in the Operator column.
8. Click Save As to save your integrated value set.

   • To run the integrated value set and generate the case series, click Execute.

     The ACTIVE CASE SERIES page appears with the case series.

     See Work with Case Series for more information.

   • To convert the integrated value set and advanced condition into a single advanced condition, click Convert to Advanced Condition.

     See Convert a Value Set to an Advanced Condition for more information.

For detailed information about using the Advanced Conditions Editor, see Use Advanced Conditions to Create Queries on Insight Mart.