Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
New Contributor II

hide zero\null values in map-point layer



I have a model with a map chart that display total sales of a drill down dimension of US State and Zip Codes.

If i dump the data into a table or other chart i can use the "remove null" option to hide zipcodes that i have 0 sales.

But on my map chart, after i drill in to a state, i see all the zipcodes in that state even if there are zero sales.

The "limitation" option is gray out so i can't use it either.

anyone has an idea how i can remove zipcodes that their "sum(qty)" <= 0 ?

(see attached my map with some zipcodes that has no sales, and attached data setting of my map)




Labels (3)
1 Reply
New Contributor II

Re: hide zero\null values in map-point layer

an update:

for now i found a workaround using a "left keep" between my sales table and my KML file so i don't bring any zipcode point that doesn't have sale.

but if someone know a different\better way to deal with zero\null values in map, please let me know.