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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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.