topic Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV) in GeoAnalytics

Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

bwisealiahmad — Wed, 09 May 2018 07:32:14 GMT

Hi,

In all charts we can remove values / bars etc. if they are 0 or null. How can you handle this with GeoAnalytics? I am using a linemap and showing some volume flow between countries and don't want to show the lines where they are 0 or NULL.

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

Jonas_Karlsson — Wed, 09 May 2018 07:44:46 GMT

Hi,

See below!

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Jonas Karlsson

Qlik

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

bwisealiahmad — Wed, 09 May 2018 07:46:20 GMT

Hi Jonas,

Thanks for the answer. This is for QlikView and I haven't found it here yet.

Maybe make it possible to either check it off or make the Transparcy option a Formula based field so that you can write logic on it there?

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

Ana_Yakushi — Tue, 15 May 2018 11:53:10 GMT

Hello,

If you are using Qlikview then you can use a condition for the Dimension field, something like:

=if(aggr(sum(Sales),line_id)>0,line_id)

It returns lines with Sales>0

Best Regards,

Ana Yakushi

Qlik

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

bwisealiahmad — Tue, 15 May 2018 12:00:21 GMT

I tried something similar...

So what would the expression be if this is my settings:

=if(aggr(sum(FlowValue),%Country_In_Out_Key)>0,%Country_In_Out_Key)

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

Ana_Yakushi — Tue, 15 May 2018 12:11:26 GMT

Hi,

Yes, that should work!

Best Regards,

Ana Yakushi

Qlik

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

bwisealiahmad — Tue, 22 May 2018 06:20:31 GMT

Hi,

That did not work...hmmm do you have an example .qvw where this has been done? Or any example apps online where they have done this?

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

Ana_Yakushi — Tue, 22 May 2018 07:18:32 GMT

Hello,

I made this simple demo where you can compare the Line Layer with and without the conditional dimension.

Hopefully it will be of some help.

Best Regards,

Ana Yakushi

Qlik

Re: Handling Null Values / Zeroes on LineLayer Maps (GeoAnalytics for QV)

bwisealiahmad — Fri, 25 May 2018 06:37:58 GMT

Thank you!