Conditional Variables

Overview

By using conditional or logical definitions, a conditional variable supports creating segments or groups from preexisting data contained within separate variables of your uploaded dataset. Conditional variables also have an option to "Include All Others" to make it easy to count respondents who do not fall into your defined groups.

For example, our survey data includes the age and the gender of respondents:

 

MarketSight Conditional Variables

 

Using conditional logic, we can create a new variable that views gender and age breakdowns.

 

MarketSight Conditional Variables

 

When working with conditional variables, it is important to keep in mind that values must be mutually exclusive - there can be no double counting of respondents. As a result, the order in which you define your values is important. If a respondent could fall into more than one value, he/she will only be counted once in the value that is closest to the bottom of the list. If we have a conditional with the following values:

 

  1. All Males
  2. Males, 24-30
  3. Males, 31-45

 

Any respondent who is male and who answered 31-45 will only be counted in Value 3.

 

Create a Conditional Variable

  1. On the Variables page, click New
  2. Select "Conditional" from the list
  3. Enter a name for the variable
  4. Click "Add New Value"
  5. In the new dialog, enter a name for the first value
  6. Select the first variable your conditional will be based on
    1. You can search by variable name, or
    2. Select a variable Category, and then pick from the list of variables to the right
  7. Select the desired operator
  8. Select the value from the variable
  9. Click Add to Definition
  10. Repeat as necessary, including (, ), as well as AND, OR, NOT as needed
  11. Click OK when finished defining the value
  12. Repeat steps 4 to 11 as needed until all values are created

 

Replace Clauses in a Conditional Variable

  1. Open the variable with the value definition you wish to edit
  2. Click on the value name
  3. Click on the clause that needs to be replaced
  4. The dialog dropdowns will automatically select the logic for the clause
  5. Adjust the logic as necessary
  6. Click Replace Selected Clause
  7. Click OK to confirm changes to the value
  8. Click OK again to exit the variable editor

 

Add an "Include All Others" Value

  1. After you create your first conditional value, "Include All Others" will become active
  2. Click on "Include All Others" to add it to the values list
  3. If needed, check the box next to "Include Missing" to count blank responses as well

 

 

 

 

 

Last Updated: 7/11/2019