Retrieve a value from a loaded table based on an input variable

[HugoBoyle]

Hi,

I have a Calendar file as follows loaded into my Qliksense app as table Calendar.

Year	Quarter	Period	YearWeek	Week Start Date	Week End Date	PA Week Start (Thursday prior)
2022	202201	202201	202201	02/01/2022	08/01/2022	30/12/2021
2022	202201	202201	202202	09/01/2022	15/01/2022	06/01/2022
2022	202201	202201	202203	16/01/2022	22/01/2022	13/01/2022
2022	202201	202201	202204	23/01/2022	29/01/2022	20/01/2022
2022	202201	202202	202205	30/01/2022	05/02/2022	27/01/2022
2022	202201	202202	202206	06/02/2022	12/02/2022	03/02/2022
2022	202201	202202	202207	13/02/2022	19/02/2022	10/02/2022
2022	202201	202202	202208	20/02/2022	26/02/2022	17/02/2022
2022	202201	202203	202209	27/02/2022	05/03/2022	24/02/2022
2022	202201	202203	202210	06/03/2022	12/03/2022	03/03/2022
2022	202201	202203	202211	13/03/2022	19/03/2022	10/03/2022
2022	202201	202203	202212	20/03/2022	26/03/2022	17/03/2022
2022	202201	202204	202213	27/03/2022	02/04/2022	24/03/2022
2022	202202	202204	202214	03/04/2022	09/04/2022	31/03/2022
2022	202202	202204	202215	10/04/2022	16/04/2022	07/04/2022
2022	202202	202204	202216	17/04/2022	23/04/2022	14/04/2022
2022	202202	202205	202217	24/04/2022	30/04/2022	21/04/2022
2022	202202	202205	202218	01/05/2022	07/05/2022	28/04/2022
2022	202202	202205	202219	08/05/2022	14/05/2022	05/05/2022

I have created an app in Qliksense that allows the user to enter a Year/Week number.

I have stored this input into a Variable vSalesYYYYWW.

What I want to do is retrieve the 'Week End Date' value for the entered Year/Week.

So if the user enters Year/Week value of 202217 I want to retrieve the value of 30/04/2022.

If the user enters a Year/Week value of 202208 I want to retrieve a value of 26/02/2022.

Is there a way that this can be done ?

I tried this 

=MIN({<YearWeek = { '( =$(vSalesYYYYWW) )' }>} [Week End Date])

but this only shows me the Minimum value in the 'Week End Date' column regardless of the value in the variable vSalesYYYYWW.

[joaopaulo_delco · Accepted solution]

Hi @HugoBoyle !

     I tried the following expression and it works.

MIN({<YearWeek = {"$(=vSalesYYYYWW)"}>} [Week End Date])