Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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?
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
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)
?
Hi,
Yes, that should work!
Best Regards,
Ana Yakushi
Qlik
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?
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
Thank you!