MicroStrategy ONE

How to Filter with Attribute Form Qualifications

You can qualify on attribute forms using the Where operator. Once you select an attribute form, you can use various logical and mathematical operators to create a view filter qualification based on an attribute form, to restrict data. You can use any of the following operators in attribute form qualifications.

Comparison Operators

Comparison operators compare values. The values can be numbers, text strings, or expressions. The options are:

  • Equals
  • Does not equal
  • Greater than
  • Greater than or equal to
  • Less than
  • Less than or equal to
  • Between (enter value 1;value 2)
  • Not between (enter value 1;value 2)
  • Is Null
  • Is Not Null
  • In (enter value 1;value2; . . . ;valueN)
  • Not In (enter value 1;value2; . . .;valueN)

Pattern Operators

Pattern operators allow text strings to be compared. Pattern operators are case-sensitive. The options are:

  • Contains
  • Does not contain
  • Begins with
  • Does not begin with
  • Ends with
  • Does not end with
  • Like
  • Not Like