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: 
bwisealiahmad
Partner - Specialist
Partner - Specialist

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

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.

1 Solution

Accepted Solutions
Ana_Yakushi
Employee
Employee

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

View solution in original post

8 Replies
Jonas_Karlsson
Employee
Employee

Hi,

See below!

Untitled.png

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

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

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?

Ana_Yakushi
Employee
Employee

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

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

I tried something similar...

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

QVMaps.PNG

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

?

Ana_Yakushi
Employee
Employee

Hi,

Yes, that should work!

Best Regards,

Ana Yakushi

Qlik

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

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?

Ana_Yakushi
Employee
Employee

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

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

Thank you!