Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let's say I have a Product field with values A, B, C, D, E. I want to display a text box when A or B or both A & B are in the selection criteria. So basically pass when:
Product NOT IN('A','B')
What is the syntax I need to use in QV to do this? I've tried things like this, but I can only get it to work if I have one or the other selected. When I select both, then the text box shows up.
-- Product <> 'A' and Product <> 'B' and Product <> ('B' and 'A')
-- NOT(Product = 'A' or Product = 'B')
(and I worded that first part badly... I want the text box to show when A or B is not selected.)
Hi, try this:
=sum(aggr(if(match(Field, 'A','B'),1,0),Field)) = 0
Regards.
Yep, that did the trick! It shows the box if I pick just A, just B, or A&B.
I think I'll probably want to also show it when someone picks A,B,C, but I get the concept so I can figure that out later.
Thanks!