MicroStrategy ONE
Joining filter qualifications with operators: AND
Before you begin
This topic assumes that you are familiar with filters. For background information, see About filters, Types of qualifications, and About view filters.
By default, the operator AND is inserted between filter qualifications.
The following images show the initial report with no filter, and the resulting report after two filter qualifications are applied and joined with AND. The initial report with no filter appears as follows:
After the filter (Year = 2026) And (Region = Northeast) is applied, the report appears as follows:
The following diagram shows the impact of the AND operator on a result set:
The shaded area represents the report's result set, which contains only revenue generated in the Northeast in 2026.