Excluding zero values on a map chart

[Aika]

Hi,
I have a map chart and I need to be able to exclude cities with zero values.

For example I would like the city "Mara" not to appear on the map because it is associated with a value (n° debitori paganti) = 0

I am trying with the following function:
if (debtor_number = '0', Null (), city)
then I exclude null values from the map properties, but it doesn't work ...
How can I do?

This is the map:

[wayne-a]

Hi, not sure about the map chart but other charts have an "Add Ons" property with a "Data Handling"  setting.  By default it is checked to include zero values, you can uncheck it to exclude them.

[Gui_Approbato · Accepted solution]

Hello Aika,

You can use the Aggr function in the dimension.

Instead of City in the dimension, use it wil a condition (similar with what you did but a but with a plus):

Aggr( if(debtor_number <>'0', City ) , City) 

Check if it works.

Regards

[Aika]

thanks it works!