Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Choosing more than one value for text box conditionality

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')

3 Replies
Not applicable
Author

(and I worded that first part badly... I want the text box to show when A or B is not selected.)

Not applicable
Author

Hi, try this:

=sum(aggr(if(match(Field, 'A','B'),1,0),Field)) = 0

Regards.

Not applicable
Author

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!