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

[Simon88]

 @Qiu

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

[Yoshiro_Fujimori · Accepted solution]

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

[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%2...

[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?

[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).