Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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