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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
User0
Contributor III
Contributor III

Select only current year , previous year and previous to previous year from year dimension

Hi , 
I have a dimension 'Year' and I only want to show three years as default , I have remaining years in the filter, the user can choose more years from .

Please help.

Labels (6)
2 Replies
vinieme12
Champion III
Champion III

As below

 

=Aggr(only({<Year={">=max(Year)-3"}>} Year),Year)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
justISO
Specialist
Specialist

Hi, you can create 'default' bookmark with manually selected or selected dynamically years, like 

{<[Year]={"=[Year]>=year(today())-2"}>}

and make that bookmark as default, so whenever you open app, year filter will be applied, but other values also can be filtered.