Using Text Box Action to select range of Dates

[ZoeM]

Hi Community.

I need to create a text box that will have an action to select all items between a range of dates.

E.g. Select all items to be manufactured a week from today (One Week Out), Two weeks Out 4 Weeks Out etc...

The result will be 4 text boxes with actions: (1 Week, 2 Week, 3 Week, 4 Week).

Thanks for all your help!

[PabloTrevisan]

Hi Zoe,

Use this script in the LOAD statement:

You should set the period .. I used current date -5 to 1 week for example

The result on dashboard:

I hope this solves your problem.

[ZoeM]

Thanks for looking into this Pablo. I ended up creating the buckets in Alteryx as I could not find a way to do it in QVW. However, I would like to know the syntax in Set Analysis that could allow me to calculate the dates without alteirng the script.

[PabloTrevisan]

I had understood that what you wanted was a way to create the periods. Sorry for not being able to help you. I did not quite understand your return, but if the topic was closed please mark it as the right answer. thank you.

[ZoeM]

Thanks Pablo.