topic Re: Group dimension depending on values in QlikView

Group dimension depending on values

Thu, 23 Apr 2015 15:30:10 GMT

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?

Re: Group dimension depending on values

Oleg_Troyansky — Thu, 23 Apr 2015 15:45:11 GMT

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!

Re: Group dimension depending on values

Thu, 23 Apr 2015 15:57:37 GMT

Thanks for the quick response!