When you select a variable in the Variable List in the Filter or Edit Category dialog, you can define the conditions for that variable. For example, if the variable stores the respondent's gender, you might want to specify that the gender must be female. How you define the conditions depends on the variable’s type:
The conditions must be based on the values that are actually stored in the variables. For example, when you filter on a categorical variable, you can base the condition on the responses to that variable, but you cannot base the conditions on any statistical elements that you have defined for the variable on the Edit tab in the Edit Variable dialog (see
Edit Variable dialog) or New Variable dialog (see
New Variable dialog). Similarly, when you filter on a numeric variable, you must base the filter condition on the raw numeric values stored in the variable and you cannot reference any bands that you have set up for the variable on the Banding tab. This is true for both the Filter and the Edit Category dialogs and applies when you use both normal and advanced mode.
The reason for this is that the Edit, Banding, and Script tabs in the Edit Variable and New Variable dialogs only control how the variable appears when you include it on the side or top of a table. They do not define the structure of the variable.