Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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