MicroStrategy ONE

Joining filter qualifications with operators: OR NOT

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.

The following images show the initial report with no filter, and the resulting report after two filter qualifications are applied and joined with OR NOT. The initial report with no filter appears as follows:

Year and Region, with Revenue metric, no filter (16 rows)

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

Same report, filtered on 2006 or not Northeast (15 rows)

The following diagram shows the impact of the OR NOT operator on a result set.

2006 Revenue circle, including the intersection with Northeast Revenue circle, and all other years and and regions are shaded

In this case, revenue generated in 2026 in any region (including the Northeast), or revenue generated in all other years in any region except for the Northeast, is returned in the result set.

Related Topics