How do I make a Drop Down (or List Box) change a Filter in an Analytic App?

Hi everyone,
I’m new to Alteryx macros/Analytic Apps. I have a main dataset with a text field [Data] and a separate unique list of values. I want a Drop Down (single select) — or List Box if multi-select is easier — so that when the user chooses an item, the Filter updates and keeps only matching rows.

Could someone show the simplest, correct setup (or a tiny example workflow)?
I’m not sure how to pass the selected value(s) into the Filter expression via an Action.

Thank you!
Simon

DATA.xlsx

Drop Down.yxwz

List.xlsx

Apps

Batch Macro

Interface Tools

Accepted answers

Yoshiro_Fujimori

Hi @Simon88 ,

You need to pass the list of values to List Box tool in the form of "Fields from Connected Tool".

So first you need to prepare a table with fields which have the names you want to display on the App.

You may feel the attached App might be a bit lengthy, but I tried to keep the order of the names on the list.

I hope this helps. Good luck.

Workflow

List Box

App Image

Drop Down.yxzp

All comments

Yoshiro_Fujimori

Hi @Simon88 ,

You need to pass the list of values to List Box tool in the form of "Fields from Connected Tool".

So first you need to prepare a table with fields which have the names you want to display on the App.

You may feel the attached App might be a bit lengthy, but I tried to keep the order of the names on the list.

I hope this helps. Good luck.

Workflow

List Box

App Image

Drop Down.yxzp

Simon88

Thank you.

Yoshiro_Fujimori

You can just double-click the .yxwz file.

Or you can open it from Designer with "Run as Analytic App" button next to "Run" button on the Top Right of the Designer Canvas.

If you are not familiar with these operations, I would recommend taking the Interactive Lessons for Apps.

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%20Analytic%20Apps

Simon88

Hi Yoshiro_Fujimori ,

Thank you. If I want to use the data coming from this filter in another tool, is that possible?

Best regards,
Simon

Yoshiro_Fujimori

Of course you can use the data by simply connecting any tool to the output anchor of the filter tool.

If you find any difficulties in doing so, please describe the issue in more detail.

Simon88

Hi @Yoshiro_Fujimori ,

Thanks again for your help.

I'm trying to use the analytic app. I've selected a field, like Patient Events, but after I click "Finish," the app doesn't seem to be running. Is there something else I need to do?

Drop Down_1.yxzp

Yoshiro_Fujimori

There are two issues in your Analytics App.

Please compare the App I attached with yours.

The expression in Filter Tool is

Mine >> [Data] IN ("Registration")

Yours >> [Data] Equals "PLACEEROLDER"

You need to use "IN" instead of "=", because you want to filter with a "List" of field names, instead of a exact field name.

Next, Action tool is set as below in your App.

In [Replace a specific string:], you need to replace the exact string in the Filtering expression, which is "PLACEEROLDER".

List Box Tool generates the list of the selected values in the form of "Field name 1","Field name 2","Field name 3".

With the list, Action Tool replaces the string "PLACEEROLDER" in Filter Tool.

Eventually, Filter Tool filters the data with the expression;[Data] IN ("Field name 1","Field name 2","Field name 3") .

I hope this helps. Good luck.

Simon88

Hi @Yoshiro_Fujimori ,

I have used your file.

When I want to select expect Registration in Alteryx Analytic App app results shows

But when I slect Ok on App results then I need to select Finish on Alteryx Dessiner Analytics App. Then nothing chanaged in Filter and still shows Registration.

Could you please help me with this?

Yoshiro_Fujimori

I am not sure if I understand correctly, but if you mean as below, it is normal.

When you "run as Analytic App", it works as expected.
When you press "Run" button, it works as the original filtering.

After all, as the final deliverable, the end user would not use Designer.

The user would run the Analytic App (i.e. double-click the .yxwz file or run on Server).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703