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

HugoBoyle — Thu, 13 Jul 2023 15:50:37 GMT

Hi,

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

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.

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

joaopaulo_delco — Thu, 13 Jul 2023 17:30:10 GMT

I tried the following expression and it works.

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