topic Re: Remove zero values from maps in App Development

Remove zero values from maps

sforrester — Sat, 16 Nov 2024 07:47:47 GMT

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).

Re: Remove zero values from maps

PabloTrevisan — Mon, 20 Aug 2018 18:35:21 GMT

Hi Shana,

Could you send me your qvf ? Wath version of qliksense ?

Re: Remove zero values from maps

sforrester — Mon, 20 Aug 2018 19:35:25 GMT

Sure, I'm using Qlik Sense desktop June 2018. I noticed it first in our enterprise instance (April 2018 release) so I decided to play with it on my desktop to see if the June release had any fixes or enhancements. See attached for .qvf.

Re: Remove zero values from maps

PabloTrevisan — Mon, 20 Aug 2018 20:05:25 GMT

I believe this solves your problem.

Re: Remove zero values from maps

sforrester — Mon, 20 Aug 2018 20:14:46 GMT

So we have to create a calculated dimension to remove zeros then? How will this impact reloads when we're dealing with millions of rows of data?

Re: Remove zero values from maps

PabloTrevisan — Mon, 20 Aug 2018 20:18:46 GMT

In my opinion there is no other way for the dashboard, if you want to have more performance you have to do this calculation via SCRIPT, you have to test the impact, I thought of something quick and simple to help you.

Re: Remove zero values from maps

sforrester — Mon, 20 Aug 2018 20:29:14 GMT

So I implemented this calculated dimension but now there is some data that is not plotting on the map unless I select it elsewhere.

Image 1: Cities showing with State of CA selected. Note Death Valley is not showing on the map.

Image 2: City of Death Valley selected from a table. It now shows up on the map

Re: Remove zero values from maps

PabloTrevisan — Mon, 20 Aug 2018 21:28:38 GMT

I did some testing, this is happening on your initial model, before I even make changes. Are you using a KML to draw cities?

Re: Remove zero values from maps

bwisealiahmad — Tue, 21 Aug 2018 07:22:33 GMT

Hi,

Do it in the script as Pablo mentioned above. If you could share some rows then we could help out with that.

Best,

Ali A

Re: Remove zero values from maps

sforrester — Tue, 21 Aug 2018 12:54:35 GMT

no, that is the plan for very soon, we just haven't implemented it yet. I figured that would help fill in the areas Qlik isn't finding on it's own. Thanks for the help on this one! I marked your answer above correct.

Re: Remove zero values from maps

PacoRios — Fri, 01 Feb 2019 11:47:57 GMT

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