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