Exclude Box Tool

Use the Exclude Box tool on a Query Form to create a container in a query form within which child elements are OR’d together by default and then excluded from the selection. Exclude boxes can be saved as templates, which offer a useful way of saving and reusing complex suppressions.

For example:

Procedure

1. Drag the tool from the tool box, or select it from the Create new drop-down.
2. Add an optional Name and click into the Resolution Level field to select an appropriate resolution table. Note that the elements within the box can be calculated at different resolution levels and then 'rolled up' by the resolution level specified for the box.
3. Drag tools from the toolbox to populate the Exclude box with questions. Alternatively select options from the Create new drop-down within the AND box.

When adding questions to the box, take care that you are adding them to the actual box and not below it. When in Edit mode, questions within an Exclude box are slightly indented. When viewing the final question sheet, it is not possible to tell which questions are contained within the Exclude box, so your question should be worded to ensure that the end user knows that it is an Exclude.

• Query Forms
  • Creating a Query Form
  • And Box
  • Column Value
  • Date Range
  • Embedded Item
  • Exclude Box
  • Header
  • Numeric Range
  • List of Values
  • Or Box
  • Parameter Box
  • Query Form Tool
  • Segment Editor
  • Sub Heading
  • Substitution Parameter
  • Use Parameter tool
  • Yes No Question