List Expression (in, not in)

// in
country in (1,2,3)
age in (30...40) // this means 30 >= age <= 40
age in (30...40) and age != 40 // 30 >= age < 40
asdf in (1,2,3,5...9,10)

// not in
q1 not in (1,2,3)

Used in Measures

pct(q5 in (8,9,10))
pct(q5 in (8...10))
sum(country in (1,2,3) ? score1 : score2) // (mixed with ternary condition just for fun)

Used in Groups

month in (10,11,12)
hhincome in (3,4,5,6)
segment==1 and ownership not in (1,2)