Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Clerwyr
Contributor II
Contributor II

Filter and variable

Hi everybody !

I try to use a filter with a variable like this exemple :

2019-10-18_14h52_30.png

The question is : How can I do to have years before the actual year ? Like <=year(toay()) but it don't works.

The goal is to have de default application filter using this variable.

Thanks !

Labels (3)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=Annee_Affaire<=Year(Today())

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

=Annee_Affaire<=Year(Today())

Clerwyr
Contributor II
Contributor II
Author

Thanks Tresesco ! It works !