Alteryx Designer Desktop Discussions

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

Use List box to change variable in Formula

Bwilliams
6 - Meteoroid

I know this is a basic issue but for some reason, I can not get it to work properly for me.  I have a list box that has options for Q1, Q2, Q3. I want users to select which option they wish to run(Q1 or Q2 or Q3) and based on the user's selections the variable will change to the selection in the formula tool. 

 

Bwilliams_1-1657616036298.png

So if user select Q1 all the variable will be Q1 in the formula tool

 

From the image i want the variable to be users selections. 

 

Bwilliams_0-1657615966728.png

 

4 REPLIES 4
grazitti_sapna
17 - Castor

@Bwilliams, try something like this.

 

grazitti_sapna_0-1657617397780.png

 

grazitti_sapna_1-1657617407019.png

grazitti_sapna_2-1657617414747.png

 

Output

grazitti_sapna_3-1657617449542.png

 

 

Attaching the sample workflow.

 

I hope this helps!

 

Thanks!

 

Sapna Gupta
DataNath
17 - Castor

@Bwilliams if you just want the user to make a single selection, I'd recommend using a dropdown instead of a list box. How is your Action tool configured? I'd imagine that's the most likely cause. Are you making sure to only update the specific part of your expression, like so?

 

DataNath_0-1657617564121.pngDataNath_1-1657617570824.png

 

Bwilliams
6 - Meteoroid

@grazitti_sapna  thanks this was helpful, didn't resolve my issue but give me another idea on how it can be done. however, how can the output shown in the app output be also shown in the browse tool.

grazitti_sapna
17 - Castor

@Bwilliams, will it be possible for you to share a sample dataset and the workflow that you are trying to implement so that I can make amendments to the same?

 

Thanks!

Sapna Gupta
Labels