Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!