Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Aika
Contributor III
Contributor III

Excluding zero values on a map chart

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:

map-chart.jpg

1 Solution

Accepted Solutions
Gui_Approbato
Creator III
Creator III

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

View solution in original post

3 Replies
wayne-a
Creator
Creator

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.

 

wayneantinorea_0-1627383389504.png

 

Gui_Approbato
Creator III
Creator III

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
Contributor III
Contributor III
Author

thanks it works!