Filter Responses

This article will show you how to filter (hide) multiple response questions based on the answers to another question


Background

It is very common to have a question where you ask respondents to select all the brands they are aware of. Then the following question asks you about usage for the same brands. This article will show you how to easily account for this while programming. 

This is sometimes referred to as "carry forward" logic.


Directions

  • Program your initial question with the full list of response options. Lets call this "Q1". 
  • Program your follow-up question with the full list of response options. Lets call this "Q2".
    • In some cases you may want to use a 'Shared List'. This is not required but is an option available to you. 
  • In your follow-up question, access the 'Overall Question Settings'.
  • Search for the 'Filter Responses' option. Here you will be able to type in a formula which will filter OUT items if the statement is true. 
    • If you have a grid question you will have multiple 'Filter Responses' fields because you have rows and columns. Just use the appropriate one depending on your needs. You can even use both should your use case require it.

Examples

Example 1: Checkbox to Checkbox
"Q1" is a 'Checkbox' (select all that apply) question and 'Q2' is another checkbox question. 

  • Follow the directions above to access the 'Filter Responses' setting
  • You now have a number of ways to write this statement such as:
    • TRY("Q1_" . X) !=1
      • This is the most common and universal way to accomplish a filter. It also allows you to have ten options in "Q1" (with option ten being an opt-out). Then in "Q2" you have the same list without the opt-out.  This will ignore the opt-out punch because it does not exist in "Q2". 
      • If you are ever in doubt, use this syntax.
    • PARSE("Q1_" . X) !=1
      • This is similar to the "TRY" formula above but it will NOT ignore the missing punches. It will throw an error while you test the survey. 
    • Q1:X !=1
      • Use this option if you have identical lists in both questions. Meaning the punch numbers match and the number of punches match. If you have an additional opt out in "Q1" which you have not programmed in "Q2" then you should NOT use this option. 
    • !(Q1 HAS [X])
      • Use this option if you have identical lists in both questions. Meaning the punch numbers match and the number of punches match. If you have an additional opt out in "Q1" which you have not programmed in "Q2" then you should NOT use this option.

Example 2: Radio (Select One) to Any Other Question Type
"Q1" is a 'Radio' (select one) and "Q2"  is a 'Checkbox' (select all that apply) question. Lets say "Q1" is a 'Radio' question which asks how many of something you have purchased and you want to show the identical response list in "Q2" conditionally based on your answer to "Q1". 

  • Follow the directions above to access the 'Filter Responses' setting
  • You now have a number of ways to write this statement depending on what you want to appear:
    • X > Q1
      • This is saying hide all of the response options in "Q2" which are greater than the answer to "Q1". This would work to show any items which were less than or equal to the corresponding option in "Q1". 
    • X < Q1
      • This is saying hide all of the response options in "Q2" which are less than the answer to "Q1".
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us