Using Assisted Mode to define a filter (AskiaVista)

In assisted mode, you use a simple interface to build up your filter. This interface is easy to use, but it allows you to create fairly sophisticated filters. However, if you need to create an even more complex condition, you can do so using AskiaScript in script mode.

Example A: Filter created from a category question

Suppose we want to filter our tables by respondent gender; we might create a filter based on a question Gender. We have selected the question Gender, then the category Man. Our filter corresponds to all the males interviewed in this survey. We might set up our condition as follows:

Example B: Filter created from a numeric question

Suppose we want to specify respondents who gave a value greater than 5 at the question Department. In our example, we have selected the question Department, then greater. Finally, we have entered the value 5:

Building your filter

A filters consists of one or more logical conditions. To define a condition, select the question you want to base it on, and then define the response you expect if the condition is to be satisfied.

For closed questions, you select one or more closed responses, and an operator which determines which of these the respondent must have selected in order to satisfy the condition. The available operators are:

• At least one: At least one of the specified responses must have been selected by the respondent. It does not matter is he/she selected any responses outside of those specified.

• None: None of the specified responses must have been selected by the respondent. It does not matter is he/she selected any responses outside of those specified.

• All: All of the specified responses must have been selected by the respondent. It does not matter is he/she selected any responses outside of those specified.

• At least one and no other: At least one of the specified responses must have been selected by the respondent, and he/she must not have selected any responses outside of those specified.

• All and no other: All of the specified responses must have been selected by the respondent, and he/she must not have selected any responses outside of those specified.

For example, the following condition is true if the respondent is younger than 35:

For numeric questions, you need to enter a value, or a range of values, and specify how the answer given by the respondent must relate to this value in order for the filter to be satisfied (e.g. Department Equal or less 5 means that the respondent must have answered 5 or less in the question Department to satisfy the filter). The available operators are:

• Less: The condition is true if the respondent's answer was less than the value you specified.

• Equal or less: The condition is true if the respondent's answer was equal to or less than the value you specified.

• Greater: The condition is true if the respondent's answer was greater than the value you specified.

• Equal or greater: The condition is true if the respondent's answer was equal to or greater than the value you specified.

• Equal: The condition is true if the respondent's answer was equal to the value you specified.

• Different: The condition is true if the respondent's answer was different from (i.e. not equal to) the value you specified.

• Between: The condition is true if the respondent's answer was between the two values you specified (e.g. if you entered 5 and 10, then the condition is true if the respondent answered 5, 6, 7, 8, 9 or 10).

• Out of: The condition is true if the respondent's answer was outside of the two values you specified (e.g. if you entered 5 and 10, then the condition is true if the respondent gave an answer less than 5 or greater than 10).

• Don't know: The condition is true if the respondent answered don't know.

Multiple conditions

Your filter can consist of several conditions. To add another condition, click + on the row beneath the condition:

You can define the relationship between each of these conditions (e.g. with two conditions, they might both have to be true, or only one of them may have to be true to satisfy the filter). Select the appropriate operator between the two conditions:

• AND: Both conditions must be true for the filter to be satisfied.
• OR: Only one of the conditions must be true for the filter to be satisfied.

For example, the following condition is true if the respondent is aged 25-34 or 35-49 (in other words, if the respondent is aged 25-49):

To remove a condition, click - beneath it:

You can also create sub-conditions that combine to make conditions. To add a sub-condition, click + on the same row as the condition:

To remove it, click - on the same row as the condition:

As with conditions, you can control how two sub-conditions combine by selecting AND or OR.