Sheet Actions (Select multiple values in field using variables) in QlikSense

[mattphillip]

Good morning,

I'm hoping someone might be able to assist. What I'm trying to do is set up a sheet action within QlikSense to make multiple field value selections - but using values stored in variables. My attempt is below. Bascially, I want it to select the current date, then the corresponding dates for the previous three years. The code in the variables produces the desired results when popped in a textbox but I can't get the sheet action to work.

='(max(ReportDate|vPreviousYear|vPreviousYearMinusOne|vPreviousYearMinusTwo)'

I've tried wrapping the variables with $(<variable name>) but this didn't work. Any help would be most appreciated.

Matt

[rubenmarin]

Hi, I would first try wit fixed values until it works, something like:

="05/09/2022|05/09/2021|05/09/2020"

When it works you just need to change the fixed values to variables, somehting like:

="$(=Date(Max(ReportDate))))|$(vPreviousYear)|$(vPreviousYearMinusOne)"

[mattphillip]

Unfortunately still no luck. Thank you for the suggestion though.