https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1774430#M454779 <P>if the user selects only one date, then only one week is possible.&nbsp; you can just straight away assign the possible week selection by&nbsp;<BR /><BR />=only(week)&nbsp; //assuming week is the field for the week number</P> Thu, 14 Jan 2021 15:16:06 GMT edwin 2021-01-14T15:16:06Z https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1774319#M454775 I am sure I am missing something very straightforward, so some assistance would be appreciated. In my load script I load a master calendar, Which has a range of dates corresponding to the range of dates in the transaction file, plus the number of the week in the year. The date links to a date field in the transaction file I am loading. I want the user to enter a date (any date in the range of the master calendar) which I store in a variable I called 'vInputDate'. Based on the date the user enters I want to assign a variable the corresponding value of the week variable. Thu, 14 Jan 2021 10:53:56 GMT https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1774319#M454775 EverleighPresley 2021-01-14T10:53:56Z https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1774430#M454779 <P>if the user selects only one date, then only one week is possible.&nbsp; you can just straight away assign the possible week selection by&nbsp;<BR /><BR />=only(week)&nbsp; //assuming week is the field for the week number</P> Thu, 14 Jan 2021 15:16:06 GMT https://community.qlik.com/t5/QlikView/Calculating-a-variable-from-an-input-field/m-p/1774430#M454779 edwin 2021-01-14T15:16:06Z