Group dimension depending on values

[#1]

Hi,

I have a question I hope someone can answer me.

I have chart with the dimensions month and country and a expression, sales. It's a stacked bar chart (countries). The problem is that I've got many  countries and some have really little sales and the chart it's confusing. So what I want to do, is to group the countries with small sales in one "country". For example, to group all the countries that have sales lower than 20% of the total in others,and not group the ones that have sales bigger than the 20% and keep the original country.
Is that possible?

[Oleg_Troyansky · Accepted solution]

Assuming that you use QlikView ver. 11.x, - you described the standard feature "Dimension Limits", with the use of "Others" - this is exactly what it does. Check it out!

[#3]

Thanks for the quick response!