This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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) = 0I 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:
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.
View solution in original post
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.
thanks it works!