Using the Filter with multiple parameters

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

Output

Accepted answers

RolandSchubert

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

All comments

zajaccount

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

Hi @jmlabelle65 ,

I think, some brackets are needed:

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703