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

APP Filter Not Updating

tandon
8 - Asteroid

Hi, I am trying to update formula using drop down filter however it's not updating and returned below error. It appears, it;s trying to update the operator (in formula) while selecting the value from drop down. In formula - it;s quite simple and I would like to update the values based on drop down selection. Please suggest where I am doing it wrong.

 

tandon_0-1653577958704.png

Error

tandon_1-1653578038514.png

 

 

 

 

 

10 REPLIES 10
DavidSkaife
13 - Pulsar

Hi @tandon 

 

Are you able to share your workflow so we can see the settings you have applied?

DataNath
17 - Castor

Hey @tandon, in your action tool, have you reduced what you are replacing to just include the 001A part of the formula?

 

Will need to tick 'Replace a specific string' and reduce it down to just that, like so:

 

DataNath_0-1653578506383.png

DataNath_0-1653578915780.png

 

 

tandon
8 - Asteroid

I can;t upload the files as it;s blocked however I can share settings. please refer below

 

Filter settings - 

 

tandon_0-1653578487891.png

 

Drop down setting

 

 

 

 

 

 

IraWatt
17 - Castor
17 - Castor

Hey @tandon,

Think you are doing this, your updating the operator not the value:

IraWatt_0-1653578577974.png

What you need to do is update what is being filtered on by highlighting here:

IraWatt_1-1653578629539.png

 

tandon
8 - Asteroid

Thanks @IraWatt , I applied above setting however received below now. I tried to open debug but I can still see old values which means values not updated via dropdown.

 

tandon_0-1653579227252.png

 

 

IraWatt
17 - Castor
17 - Castor

Hey @tandon,

Add two brows tools like and add them as outputs in the interface designer to see what your filter is doing.

IraWatt_0-1653579756760.png

I've attached an example workflow:

IraWatt_1-1653580048479.png

Also make sure to run the workflow if you change any of the data before running the app in debug.

 

tandon
8 - Asteroid

Thanks @IraWatt . I added output and can see values appeared however operand variable didn;t updated with selected value

 

tandon_0-1653580230376.png

 

 

IraWatt
17 - Castor
17 - Castor

No worries @tandon :) looking at my example I have set a value in the filter as a default which I think overwrite, strangely you don't seem to have a value there.

IraWatt_0-1653580513022.png

Try setting your filter to custom

IraWatt_1-1653580635333.png

Then replacing the specific section of it like this 

IraWatt_2-1653580692031.png

 

tandon
8 - Asteroid

Yes. agreed with you as I expect value here but anyway it;s working as I can see output. thanks for your help.

Labels