topic Re: Using Text Box Action to select range of Dates in QlikView

Using Text Box Action to select range of Dates

ZoeM — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Using Text Box Action to select range of Dates

PabloTrevisan — Wed, 18 Jul 2018 14:36:51 GMT

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.

Re: Using Text Box Action to select range of Dates

ZoeM — Wed, 18 Jul 2018 18:07:30 GMT

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.

Re: Using Text Box Action to select range of Dates

PabloTrevisan — Wed, 18 Jul 2018 20:57:48 GMT

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.

Re: Using Text Box Action to select range of Dates

ZoeM — Wed, 18 Jul 2018 21:51:16 GMT

Thanks Pablo.