Alteryx Designer Desktop Discussions

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

Filtering Country

ankitgupta
7 - Meteor

Hi All, I want to filter More than One Country using "Filter" option by using Basic Filters , can you please suggest how to solve this.

 

Thx

Ankit 

4 REPLIES 4
Kenda
16 - Nebula
16 - Nebula

@ankitgupta Could you use a Filter tool and type out your criteria like below? The '||' represents OR.

 

country filter.PNG

LordNeilLord
15 - Aurora

Hey @ankitgupta,

 

EDIT: What @Kenda said

 

Change your filter from Basic to Custom then use the || or OR operator:

 

Custom Filter.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Claje
14 - Magnetar

One other option if you want to use a lot of countries would be

[Country] IN ('Spain','France','Germany','Japan')

This way you can simply keep a list and won't have to type out "Country =" over and over.

LordNeilLord
15 - Aurora

@Claje

 

Good point! I always forget about IN

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Labels