topic Re: how to filter different drop downs in Alteryx Designer Desktop Discussions

how to filter different drop downs

swapsingh2712 — Thu, 09 Sep 2021 14:22:39 GMT

Hello all,

I'm trying to create a workflow where user can select the manager name in the drop down menu and based on the selection it shows the all the analyst name that reports only to him in the next drop down. but it's not working.

basically this workflow will select the manager, analyst and then update the asset count.

once you select the manager name in the first dropdown, it should only show the analyst name that reports to him. after that it will update the asset count based on the selection.

I've attached my data set and alteryx workflow. please advise

Note: The data set contains more then thousand values. I just provided few data vales in excel

regards,

swapsingh2712

Re: how to filter different drop downs

atcodedog05 — Thu, 09 Sep 2021 14:26:54 GMT

Hi @swapsingh2712

This definitely seems like a job of chain apps.

Here are resources.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

A weekly challenge which had similar usecase : https://community.alteryx.com/t5/Weekly-Challenge/Challenge-218-Car-Sales-Reporting/td-p/580155

https://community.alteryx.com/t5/Videos/Chained-Applications/td-p/186301

Hope this helps : )

Re: how to filter different drop downs

atcodedog05 — Thu, 09 Sep 2021 14:36:45 GMT

Hi @swapsingh2712

Here is how you can do it. Packaged workflow attached.

Please use this guide to downgrade the packaged workflow https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )