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:

Year and Region, with Revenue metric, no filter

After the filter (Year = 2026) And (Region = Northeast) is applied, the report appears as follows:

Same report, filtered on 2006 and Northeast (1 row)

The following diagram shows the impact of the AND operator on a result set:

Venn diagram showing the intersection of 2006 and Northeast

The shaded area represents the report's result set, which contains only revenue generated in the Northeast in 2026.

Related Topics