Qlik Sense Sheet Action - selecting multiple values

[Aurél]

Hello,

I would like the current year and last year (2022 and 2021) to be automatically selected. I manage to select a year but not 2... how do please?

Thank you.

[RafaelBarrios]

Hi @Aurél 

Try this

Its the same if values are numbers or text

hope it helps

best,

[Aurél]

Thanks, but no, that’s not what I want....
The user should not have to click on a button... I'd like to have the 2 years selected when opening the report.
In addition, I can’t enter the values, the 2 years must be dynamic to have the current year and the last year (2022 and 2021), and next year, we will automatically 2022 and 2023.

Thank you!

[RafaelBarrios]

so, same way i did with the button but in the sheets properties

my data:

load * inline [
year, city, value
2020,Caracas,100
2021,Carcas,200
2021,Paris,300
2022,Berlin,300
2022,Madrid,400
];

With value ='$(=max(year)-1);$(=max(year))'

and when the sheet opens

[Aurél]

It doesn’t work.... no year is selected

[RafaelBarrios]

please copy here the following:

1. the expression used as value

2. a filter screenshot with all values for the year field  (not the master dimension)

3. the name of the year field in the table (not the master dimension)

4. if master dimension has a formula paste it also

Best,

[Aurél]

1. ='Annee_moins_un;Annee_en_cours'

2. 

3.

Thank you :-).

[RafaelBarrios · Accepted solution]

i see

to your variables, use the '=' sign, so when you call then they are already evaluated

and in the trigger values you can not use just variables names like

='Annee_en_cours;Annee_moins_un'

by doing this qlik will look for exact text inside the field

so, you need the variables value and use this instead

='$(Annee_en_cours);$(Annee_moins_un)'

best,

[vinieme12]

Choose Action "Toggle field values"   instead

Value = ($(=var1)|$(=var2))