Filter qualification syntax

Filter qualification expressions in Command Manager use a specific syntax. For more information on the different types of filter qualifications that can be used in MicroStrategy reports, see the Filters section of the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help).

A filter can contain multiple qualifications. The set operators (AND, OR, NOT AND, NOT OR) are used to combine qualifications. For example, a filter expression for customers in the East region above the age of 20 might look like this: 'Region IN ("East") AND Customer Age@ID>20'.

Click the links below for syntax details for each type of filter qualification: