Using the Filter with multiple parameters

[jmlabelle65]

See my filter parameters below - why doesn't this work?

[ContractType] = "SiriusXM"
or
[ContractType] = "Artist Releases DB"
AND
[Status] = "ExecutedinEffect"
or
[Status] = "ExecutedFuture"
or
[Status] = "Expired"
AND
[EndDate] >= "2019-01-01"
or
IsNull([EndDate])

[zajaccount]

Hi

do you mean that it is not filtering the data correctly or does the tool refuse to work due to some incorrect syntax (resulting in an error)?

[RolandSchubert · Accepted solution]

Hi @jmlabelle65 ,

I think, some brackets are needed:

([ContractType] = "SiriusXM" or [ContractType] = "Artist Releases DB")
AND
([Status] = "ExecutedinEffect" or [Status] = "ExecutedFuture" or [Status] = "Expired")
AND
([EndDate] >= "2019-01-01" or IsNull([EndDate]))

You could also use:

[ContractType] IN( "SiriusXM", "Artist Releases DB")
AND
[Status]  IN( "ExecutedinEffect", "ExecutedFuture", "Expired")
AND
([EndDate] >= "2019-01-01" or IsNull([EndDate]))

Let me know if it works for you.

Best,

Roland

[grossal]

Hi @jmlabelle65,

You have to use () in order to make it work, else Alteryx wouldn't know the way you want it to be read.

Try it like this:

([ContractType] = "SiriusXM" or [ContractType] = "Artist Releases DB")
AND
([Status] = "ExecutedinEffect" or [Status] = "ExecutedFuture" or [Status] = "Expired")
AND
([EndDate] >= "2019-01-01" or IsNull([EndDate]))

Let me know if it worked or if we need further adjustments.

Best

Alex 

[jmlabelle65]

The second statement worked, still not sure why the first didn't - but the second was more efficient logic

Thanks and now I learned how the logic works for setting multiple parameters