Multiple Operators in Set Analysis BUT with one exclusion operator applying to only one operator.

[Ja123__]

Hi Everyone

Not sure what to search for this case but I hope I explain it sufficiently.

Let's say I want to count members:

Count ( distinct

{

< Condition 1 >

+

<Condition 2>

+ 

<Condition 3>

-

<Condition 4>

} memberID)

How do I write this so I include anything that meets criteria of Condition 1 or 2 OR ( 3 except the criteria in 4)

I basically dont want to exclude condition 4 entirely. I only want to exclude it from condition 3??

Thanks!

[bramkn · Accepted solution]

using brackets? Not sure if it works in Qlik but thats how normal set theory works.

[Ja123__]

Great had no idea that we could do that!! Thanks