Alteryx Designer Desktop Discussions

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

How to use NumericUpDown in filter

StefanusJPK
6 - Meteoroid

Hi 

 

I am looking to identify items in a listing that is above a certain value.

 

I want the user to input a value using the numeric up down.

Then I want to use that value to filter for items in the listing that is above this number.

So I would like to identify all the assets that have a value of above 45,000

I have attached the workflow and the input.

 

Is there perhaps a better way to do this than numeric up down?

 

Please help?

2 REPLIES 2
TheOC
15 - Aurora
15 - Aurora

hey @StefanusJPK 

I have configured the workflow for this, the key is in the action tool to replace a value thats already present. So i had to populate the filter with [value] > 45000, and then we can use the interface tool to change this '45000'. 

TheOC_0-1621000095038.png

 


You will have to change [value] to the column you need to change, but this should be the way to do it!

You also had it saved as a macro, it needs to be an app to allow users to select values. Hit the wand icon next to run to see the interface:

TheOC_1-1621000155412.pngTheOC_2-1621000161674.png

 



Attached is the workflow, hope this helps!
TheOC


Bulien
TheOC
15 - Aurora
15 - Aurora

hey @StefanusJPK 

I missed that you gave the input data.

Please see the attached file, is a packaged app for you, with the input data, and an output data tool to show the output.

Hope this helps!
TheOC


Bulien
Labels