Filter years in filter pane

[user467341]

Hi Qlik community,

I have a year dimension from 1990 to 2050. When I load this year dimension to my filter pane, it has 1990 to 2050.

How can I use set expression to limit this filter?

I will like to filter from 2000 (an input minimum year), and up to the current year 2022 (automatically, so if we are in 2023, the filter pane will create 2023 entry auto).

Thank you.

[BrunPierre · Accepted solution]

=Aggr(Only({<Year={">=$(=Year(Today())-1)<=$(=Year(Today()))"} >}Year),Year)