Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
drorelkouby
Contributor III
Contributor III

hide zero\null values in map-point layer

Hi,

 

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)

 

Thanks

Dror

Labels (3)
1 Reply
drorelkouby
Contributor III
Contributor III
Author

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.

 

Thanks