Desinger App - Variable for changing periods

[treibermichael]

Hello together, 

I have a short question, I just looked through this forum and couldn't find a topic that would help me (but I'm sure there is a thread with this topic).

I have a workflow where I import some data, in one column called "Periode" there are numbers for the months , so from 1 to 12.

I could manage that the import data is queried per Designer App, so the User is able to choose the data.

Now I have a filter tool selecting via "[Periode]>=1<=5" which results in a Test.xlsx and I want to add to the import data question a question for changing the periods.

My aim is, that the User doesn't have to open the workflow, so I would like to change it like this:

(Or even nicer with 2 textboxes for the starting and the ending period)

I'm not really an expert in Alteryx, it's more learning by doing, so please consider, that you are talking to an Alteryx beginner. 🙂

Hopefully you can help me.

Greets

Michael

[RolandSchubert]

Hi @treibermichael ,

if I got you right, you have to create a kind of "dynamic filter" to select the periods within the range, the user selected. 
I've attached a sample workflow to show, how to hand over selected values (I used a Numeric Up Down tool) to a Filter tool.

Let me know if it work for you.

Best,

Roland 

[treibermichael]

Hey Roland,

sorry for the late reply, I have to use Alteryx besides my "normal work" 🙂

unfortunately I can't open your Workflow, because our company still has the Designer 2019 license.

could you maybe put your solution in any kind of screenshot? Is that possible?

And thanks already for your fast reply!

Best regards

Michael

[RolandSchubert · Accepted solution]

Hi Michael,

I've added a modified version (2019.1). In general, you can change the version be editing the workflow file. Use a text editor (Notepad, Notepad ++) and replace the version entry with the version you need:

  

Hope this is helpful.

Best,

Roland

[treibermichael]

Hey Roland,

you made my day! It works, maybe it was because I used a formula, but with 2 filters asking the lower period first and the later period second it perfectly works!

Thank you very much!

Best regards

Michael