Custom Filter for 2 Conditions

Question

I have a dataset that has a column that flags records, the flags are 1,2,3,4,5. I want to add a custom filter to this data set to only select flags 2 & 5.

Currently, my expression is as follows : IF([Field1]=1 OR [Field1]=2) but I am getting an error stating it is a malformed IF statement.

what would be the proper syntax for create a filter for just flags 2 & 5?

Thank you,

rzdodson · Answer

Can confirm that @Luke_C 's first solution is likely one of the cleanest ways to filter in this use case. It enables you to filter with one statement vice setting up statements for each value you want to filter by.

Luke_C · Answer

Hi @CDIns

In the filter tool you have a few options. If the flag is a string put quotes around the value.

[Field1] in (2,5)

[Field1] = 2 OR [Field1] = 5