How to include Null Values in 'Others' rather than excluding them in qlik sense.
I want to show a pie chart with top 5 countries by sales. I have some null Values and unknown in countries which i want them to be a part of my calculation.But in some cases Nulls and unknowns also comes in my top 5 apart from others. I want those nulls and Unknown to be in calculations but these nulls and unknowns should be included in Others. How can i do it in qlik sense.