Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Update filter value using user selection

ayx-droid
7 - Meteor

I'm working on an analytic app where user selected value from dropdown list updates filter value but cannot get it right. What am I doing wrong?

 

filter.png

 

Expected output: Message would show the value selected from dropdown interface tool.

 

5 REPLIES 5
Dynamomo
11 - Bolide

@ayx-droid 

You needed to expand the Simple expression further and highlight the line that says Operand-value="Y".

when you use the Basic Filter as opposed to Custom Filter, you need to do this.

 

Dynamomo_0-1572232265760.png

ayx-droid
7 - Meteor

@Dynamomo I tried that too before posting. It still does not update the filter value.

Dynamomo
11 - Bolide

worked for me.  Here is the modified app.

let me know if you have any questions

ayx-droid
7 - Meteor

@Dynamomo Here's the result that I get:

exp.png

I'm selecting one from below:

Idr.png

 

I'm expecting to see 

fg.png or gfg.png

Dynamomo
11 - Bolide

That requires a formula tool, not a filter tool.  The filter tool selects records that are true for the expression.  The expression was changing to Type=BNR, which was selecting records where type = bnr.

you want to use the formula tool.  Update the field Type with the value being selected in the app.

see attached workflow

Dynamomo_0-1572237524752.png

Labels