topic Choosing more than one value for text box conditionality in QlikView

Choosing more than one value for text box conditionality

Thu, 03 Mar 2011 22:17:31 GMT

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

Choosing more than one value for text box conditionality

Thu, 03 Mar 2011 22:42:07 GMT

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

Choosing more than one value for text box conditionality

Thu, 03 Mar 2011 22:46:33 GMT

Hi, try this:

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

Regards.

Choosing more than one value for text box conditionality

Thu, 03 Mar 2011 23:00:02 GMT

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!