We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

filtering same column data for multiple values

harsh36
5 - Atom

hey guys, 
I'm trying to create an analytics app where the user can select multiple values from a list and the selected values would be used to filter the data. the values are from the same column. ie: [column1] = "a" or [column1]="b" 
I've been able to create the list and populate it but i'm unable to filter the data as expected. any ideas?

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @harsh36 

 

Here is an interactive lesson on list boxes https://community.alteryx.com/t5/Interactive-Lessons/Using-List-Boxes/ta-p/243116#done

 

Can you let us know what you have tried and what issue you are facing?

 

Happy to help : )

harsh36
5 - Atom

Hi ,
thank you for the lesson link it really helped. I realised i was using the wrong formula for filtering the data. I changed [state] = "a" to [state] IN ("A","B")

problem.PNG

atcodedog05
22 - Nova
22 - Nova

Happy to help and share knowledge : ) @harsh36 

Cheers and have a nice day!

Labels
Top Solution Authors