Alteryx Designer Desktop Discussions

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

Filtering Country

ankitgupta
Meteoro

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 RESPUESTAS 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
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
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
Aurora

@Claje

 

Good point! I always forget about IN

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Etiquetas