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
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

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
2,171 Views
Who Me Too'd this solution