Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor III

Qlik GeoAnalytics - Exclude Null-Values

Hi all,

I got a problem while excluding NULL-Values:

In the area plot I want to show regions when there are values. The problem is when I pick my dimension and give it a sum()-formula into the color formula it shows up all regions, doesn't matter if sum()=0 or not.

I am able not to show them by give it an aggr-formula like this:

=if('$(vEntfernungModus)' = 'Luftlinie',


    if('$(vEntfernungModus)' = 'Fahrzeit',


        if('$(vEntfernungModus)' = 'Fahrstrecke',





The problem then is that one can not select multiple regions inside the extension.

Anyone got a solution how I can select multiple regions and just show regions with values in the map?

Thanks in advance.


Tags (1)
4 Replies
Contributor III

Re: Qlik GeoAnalytics - Exclude Null-Values

Hello Sabrina,

try "not isnull()" in your if clause.

If that doesn´t work perpabs you can upload an example app.

New Contributor

Re: Qlik GeoAnalytics - Exclude Null-Values

Use if(isnull(Your expression, 0) and then select 'suppress zero values' option from presentation tab.

New Contributor III

Re: Qlik GeoAnalytics - Exclude Null-Values

‌Thanks guys. Since I am talking about the GeoAnalytics extensions in Qlikview I am wondering where this option is. I can not find it.

Anyone can tell me on how this works with this extension (I am on the newest version 5.8.2)

New Contributor III

Re: Qlik GeoAnalytics - Exclude Null-Values

THe problem is that you would need a licensed version of Qlik GeoAnalytics extension. Do you have got any experience with it? How can I supress null values here which normally is on the presentation tab of normal charts?