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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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
tresB
Champion III
Champion III

Try like:

=Annee_Affaire<=Year(Today())

View solution in original post

2 Replies
tresB
Champion III
Champion III

Try like:

=Annee_Affaire<=Year(Today())

Clerwyr
Contributor II
Contributor II
Author

Thanks Tresesco ! It works !