Using in_range Filters with Character Data

If you use an in_range filter with character data, and the From value is greater than the To value, the filter returns no results. For example, if the From value is "Zone" and the To value is "Aloe Relief", the report returns no data.

To allow results within a range regardless of whether the From value is greater than the To value, your IBM® Cognos® administrator can enable a prompting setting. For more information, see the IBM Cognos Analytics Administration and Security Guide.