QlikView GeoAnalytics Unexpected Exception Occurred Error

[mbespartochnyy]

Hi everyone,

I'm trying to recreate drill-down area map that Michael Tarallo created in his training video post, but I'm working in QlikView. I'm running into issues with Drill-down group. I've created the State Drill drill down group:

After that, I replaced the dimensions for both area layers with StateDrill drill-down group and set the Restrict Drill Down to 0 and 1:

When I click on Florida state on the map, I receive the following error:

Side note, I've followed the steps in QlikSense without issues. The error also doesn't come up in QlikView if the drill-down group simply has two dimensions, like this:

But then, the field is not fully qualified and the map looks off:

Has anyone else faced this? Any idea what could be causing this and how to fix it?

P.S. Attached is the app that I'm working on. First tab (Drill Down Area (Original)), has the two area layers that generate the error. Second tab (Drill Down Area (Unqualified)) is the one where simply a STATE and COUNTY fields are used in a drill-down group.

I came up with a workaround solution (simply do a conditional show statement to show state layer when no states are selected and qualified STATE and COUNTY field when a single state is selected) in third tab (Drill Down Area (Workaround)), but I'm still curious as to what is causing the error and if/how it can be fixed. Any input is appreciated.

Mikhail B.

[Patric_Nordstrom · Accepted solution]

Hi Mikhail,

Something seems to go wrong in the drill down with calculated dimension, I will follow that up with RD.

Meanwhile you can build the COUNTY & ',' & STATE dimension in the load script.

Or you can supply the location in the Location ID expression, and use the STATE->COUNTY drill down group.

For the state layer:

=STATE & ',' & COUNTRY & ':AADM1'

For the county layer

=COUNTY & ',' & STATE & ',' & COUNTRY & ':AADM2'

Having the location as expression also makes the selection neater when drilling down, hiding the the location type code.

By adding country in the expression the drill down will work also when using multiple countries.

County names are not unique so we're adding state info and country info. I'm also adding the location type: AADM1 and AADM2 to help the lookup service.

For more info on the location service:

http://bi.idevio.com/wp-content/qlik/qlikview/releases/IdevioMapsForQlikView-5.9.6/geometry_service....

Thanks,

Patric

[mphekin12]

I was having the same issue with the drill-down in this example and Patric's solution took care of the problem.  Thank you!

[Dolphin]

Hi @Patric_Nordstrom ,

i ran into the same issue with calculated dimensions in a drill down group.

I am running version 'February 2019 (5.15.2)'. Is this issue resolved in later versions?

Here is my example for this error:

I use two calculated dimension which are both altered by a variable switch, so they are essentially two drill down groups in one. The drill down works fine outside from GeoAnalytics but throws the described "Unexpected Exception Occurred" error when used with GeoAnalytics.

I could use two drill down groups instead and "show conditionally" but this also leads to issues similar to this post:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Discussions/Area-Layers-and-Use-Show-Condition/m-p/1...

Only thing left is to create two drill down groups and put a condition in the location fields similar to your work around.

if I use bubbles for example, they won't get visualized if the condition is not met, but will the size of each point still be calculated? That would double the calculation cost for each layer, doesn't it?

[Patric_Nordstrom]

I don't think so, if the layer is hidden no calculations are made.

Thanks,

Patric

[Dolphin]

Running 'September 2019 (5.18.3)' version of GeoAnalytics resolved the 'conditional show' bug for me.

So now, when using 'show condition', no calculation are made, but when using some condition in the location fields (as a work around to the bug decribed in the link above) they would be calculated, right? 

The issue with a drill down using calculated dimensions still remains in the current version.

[Patric_Nordstrom]

Yes, only show condition switches off the layer completely.

Thanks,

Patric