Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lea_ternat
Contributor II
Contributor II

Adding actions to sheets

Hello, 

I want to add a filtre in a sheet using : Select values matching search criteria

How can I define one criteria with two values. For more precision, I want to filter with : Match(yean,'2024','2025')

However, the action doesn't apply

Thanks for your help. 

Labels (2)
1 Solution

Accepted Solutions
Clement15
Partner - Specialist
Partner - Specialist

Hello,
You must use 'Select values ​​in Fields' with this syntax:
Field1;Field2

 

Clement15_0-1735916439210.png

 

View solution in original post

3 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,
You must use 'Select values ​​in Fields' with this syntax:
Field1;Field2

 

Clement15_0-1735916439210.png

 

lea_ternat
Contributor II
Contributor II
Author

Thanks Clément15

MatheusC
Specialist II
Specialist II

@lea_ternat 
You may also want to leave the years to change dynamically, so following the same principle as solving the @Clement15 .

='$(=year(today())-1);$(=year(today()))'

- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!