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.

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