Map Visualization shows Countries with no sales

[canerkan]

Hi everyone,

I am using QlikSense Desktop November 2018:

I am trying to create a map visualization that shows the countries we sold our goods to with the total of sales.

I have a list of our customers with the shortcuts of their countries and another list with all country shortcuts and the full names in the next column. In the third list are all sales that have been made.

My problem is, that if I use the list with all country names as dimension and 'sum(sales)' as expression, it still shows every country in this list and not only the ones we have made sales in. Does anyone know how to select only the relevant countries or am I just doing something wrong?

thank you very much in advance!

[rubenmarin · Accepted solution]

Hi Canerkan, In Localization section try filtering data with sales, ie:
=If(Count(Sales)>0,Country)

[canerkan]

Hi Rubenmarin,

thanks for your answer. You are right, thank you!

Have a good one.