Remove zero values from maps

[sforrester]

Hi there,

I am using the color by measure feature in a Qlik Sense map chart and I only want to show data that is >0. Unfortunately, Qlik is mapping areas that contain 0 values, making it look like there is data where there isn't. I've tried to change the Range to Custom with the Min at 1 and the Max at Max([Reward Amount]) but it is still showing 0s. These are not NULL values, they are calculated at 0 using an expression (Yes, I've tried un-checking the 'Include null values' box). Is there a way to omit zeros from the maps? This makes the color by measure option virtually useless for mapping calculated data.

I have also tried using an if() statement to only include values >0 but it just grays out the areas with 0s, it doesn't remove them (see 2nd image below).

[PacoRios]

Take the location to the fact table with a new value like (ZoneMap)  and use this as dimensión in your final Map.