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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Group dimension depending on values

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?

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!

Not applicable
Author

Thanks for the quick response!