Filtering based on 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. An attribute form qualification using a Contains operator that restricts data to materials that contain Economy in their DESC form is shown below.

If you use this view filter with the TOP 5 Materials by Net Sales Amount and Quarter report, the resulting report is the same as the example scenario in Filtering data based on business attributes, which uses the attribute element qualification Material In list {UC.

You can use any of the following operators in attribute form qualifications. These operators are described in detail in the Logical and Mathematical Operators for Filtering appendix in the Advanced Reporting Help:

Operator Type	Operator
Comparison Operators Comparison operators compare values. The values can be numbers, text strings, or expressions.	Exactly
	Different from
	Greater than
	Less than
	Greater than or equal to
	Less than or equal to
	Between
	Is Null
	Is Not Null
Pattern Operators Pattern operators allow text strings to be compared. Pattern operators are case-sensitive.	Like
	Not Like
	Contains
	Does not contain
	Begins with
	Does not begin with
	Ends with
	Does not end with