Quota Setup > Expression quotas > Defining expression quotas > Advanced expressions > Functions > ContainsAll
 
ContainsAll
Use the ContainsAll function to create a quota for respondents who choose all of a number of listed answers for a multiple response question.
Note You can use ContainsAll with a single response variable, but you must be careful not to specify more than one category. If you do, the expression will never select any respondents.
Syntax
variable.ContainsAll({Category1_ID, Category2_ID ...})
Note that the syntax uses the unique ID of the category rather than its label.
Example
You can define a quota for respondents who regularly drink tea and coffee as follows:
drink.ContainsAll({Tea, Coffee})
Respondents who drink only tea, only coffee, or neither beverage are excluded from the quota.
All the listed answers and no others
You can use the ContainsAll function with the Exactly flag set to true to define a quota for respondents who choose all of a number of listed categories from a multiple response question and no others.
For example, you would define a quota for respondents who drink water and nothing else as:
drink.ContainsAll({Water}, True)
See also
Functions
ContainsAny
AnswerCount