Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Who Me Too'd this solution

OmarBenSalem
MVP
MVP
‎2018-01-09 02:30 PM

Create a master dimension as follow:

=if(YearField >= aggr(Max(all YearField ),YearField )-5, YearField , 'other years')


result:

Capture.PNG

View solution in original post

1 user say ditto
1,977 Views
Who Me Too'd this solution