Show Top 5 Dimensions Based on Dimension Values

[bbergstrom]

I have a bar graph in Qlik Sense that is showing the number of sales by year.  I only want to show the top 5 years and group the remaining ones into an Other category but when I use the limitation feature it is showing the top 5 based on the measure, Sales.  Is there a way to show the current 5 years (2018 through 2014)?

[zebhashmi]

Not sure but try use set-analysis in Dimension with required Years

[OmarBenSalem · Accepted solution]

Create a master dimension as follow:

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

result:

[bbergstrom]

Thanks!  This worked.