The Library function allows you to add advanced filters.
The filter is advanced since it is created with different conditions, giving you the opportunity to collect several response options into one filter.
In other words, you can use advanced filters to add values together into one filter. Advanced filters can also be used for benchmark reports.
How to several values into one filter
In the example below, we will to add two different departments to one filter. In other words, we wish to see the collected responses for Department A and Department B under the filter Department.
1. Go to the Filters menu, under the Analysis tab, and click on the Library button. A new window will open.
2. Click on New button to create your first advanced filter. A new window will open.
3. Name your filter (this is the name stated on the table and graph), in this example we'll name the filter ADV.F:Department. Click OK to save the filter and continue.
4. Now we can add a condition/dependency to the filter.
This is necessary to do, since the filter will define which respondents you want included into the advanced filter. Therefore it is important that you remember to add one or more dependencies before you add your filter to a report.
How to add a dependencies to an advanced filter
1. Click on the New group button to add your dependency. A new window will open.
T/F: Choose if you want to create a True/False dependency.
Variable: In the drop down menu, choose the variable/question you want the dependency to refer to.
Response Option: Here you can choose if the response option should be equal, less than, more than, etc. For this example, we choose = (equal to) to the response option Department A. This means that we want all respondents with the value Department A in the variable UDV 4: Department to be included into the filter.
2. Click OK to add and save the dependency. A new window will open where you will be able to see the dependency you have added to your filter.
3. Now, we want to add Department B to this filter. Select the dependency and click the New condition button. A new window will appear.
4. Create the same condition as before, only adding Department B to the dependency.
5. Click OK to save the filter and the dependency.
The dependencies are setup the same way as in the Questionnaire tab. Read more on dependencies here.
Add a filter to a report
An advanced filter is added in the same way as a regular filter.
1. Create a report under the Analysis tab.
2. Add your report elements.
3. Go to Filters menu and click on the Append button.
4. Under Saved filters you can choose your advanced filter.
Use an advanced filter in a benchmark report
1. Follow the procedure for a benchmark report.
2. Apply the advanced filters, however an advanced filter for each of the departments must be created (ADV.F: Department A, ADV.F: Department B, ADV.F: Department C.).