Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!