When you select a variable in the Variable List in the Filter or Edit Category dialog box, you use the right side of the dialog box to 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 box (see
Edit Variable dialog box) or New Variable dialog box (see
New Variable dialog box). 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 dialog boxes 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 dialog boxes only control how the variable will appear when you include it on the side or top of a table. They do not actually define the structure of the variable.