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