cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Filter help - new user

Highlighted

I am a new user, so I thank you for your patience. I am trying to use a filter to display 4 rows in a data set based on exact account descriptions. I am trying to use the filter and OR but it is only filtering to the first record I am looking for.  I am trying to use the custom filter and typing in the following formula:

 

[F1] == "Total Property, Plant & Equipment"
OR "Capitalized Non-Network Software Fees"
OR "Customer Lists"
OR "Other Intangibles"

If I do them individually it runs as expected. Once I try to do the OR statements, I only get the first item in the formula. Can anyone please help me? I have read the filter help and thought I set this up properly. All advice is welcome. Thank you

Pulsar
Pulsar

Welcome to Alteryx and the Community!

Alteryx filters are very powerful and can run on a wide variety of different fields at once.


Because of this, your filter isn't quite specific enough.

 

If you include [F1] = after the word OR in each of these you should be all set.

EG:

[F1] == "Total Property, Plant & Equipment"
OR [F1] = "Capitalized Non-Network Software Fees"
OR [F1] = "Customer Lists"
OR [F1] = "Other Intangibles"
Quasar

@mikedesena Try this:

 

[F1] = "Total Property, Plant & Equipment"
OR [F1] = "Capitalized Non-Network Software Fees"
OR [F1] = "Customer Lists"
OR [F1] = "Other Intangibles"

Labels