topic Re: Qlik Sense Map Error: the hypercube results are too large" in App Development

Qlik Sense Map Error: the hypercube results are too large"

Sat, 09 Jan 2016 02:50:59 GMT

I wonder if anybody could help me out coz I am stucked in this Qlik Sense map issue for a long time.

I developed an app using Qlik sense to show KPI performance for each region. (there maybe many sub polygon shape for some regions) it worked pretty well on version 2.0.2. but after upgreded to 2.1.1, it does work any more, saying " the hypercube results are too large". I searched the forum, and learned that it might be there are too many polygon shapes in my map data. so I tried to use GeoAggrGeometry function to combine the polygon as said... it loaded the data successfully, but still pops up the same error message

Does anybody know what exactly reason is for my issues. some hard limit by design? what workarounds I can use, otherwise my app will die...

thanks for help or advice in advance

Re: Qlik Sense Map Error: the hypercube results are too large"

reddy-s — Sat, 09 Jan 2016 11:33:49 GMT

Hi Roger,

Yes, your guess might be correct. As a hypercube has a limit specified in in the backend like the code below:

return {

initialProperties: {

qHyperCubeDef: {

qDimensions: [],

qMeasures: [],

qInitialDataFetch: [{

qWidth: 2,

qHeight: 50

I would suggest you to use an other KML file which has only the polygons you are interested in analysing and use the background map image to display the omitted polygons like the image below.

Thanks and Regards,

Sangram Reddy.

Re: Qlik Sense Map Error: the hypercube results are too large"

Sat, 09 Jan 2016 12:04:32 GMT

Sangram, thanks for your reply!

I learned from a site which said Qlik sense only support 3333 polygons, while my KML file only has 31 state/province data, though some states have 100+ sub polygon. Yesterday, I tried to append polygon data one by one, state by state, and I did find some states with too many sub polygon will fail. So now I am wondering how can I merge these polygon areas to one polygon, you see, if it works, that means there is only total 31 polygon areas, which can supported by Qlik sense.

Do you think if it works or not? and how can I use GeoAggrGeometry function?

Re: Qlik Sense Map Error: the hypercube results are too large"

reddy-s — Sat, 09 Jan 2016 13:41:20 GMT

Hi Roger,

As you have recognised which sub areas have to be aggregated to form one polygon, I think you can achieve it using a for loop, Resident load with a where clause(Just loading the sub-polygon paths and using the GeoAggrGeometry(field_name)) and concatenate the results into one table.

As the polygon paths are not going to change hope fully . It would be better to find a KML file with the polygons you need.

Thanks and Regards,

Sangram Reddy.

Re: Qlik Sense Map Error: the hypercube results are too large"

Mon, 11 Jan 2016 03:07:38 GMT

Thanks to All who help me out!

Finally, I figured it out, here is the reason. from my experience, there is either one of following issues to trigger the mentioned map error:

1. too many polygon areas, use GeoAggrGeometry Function to merge when loading the data.

2. the precision of the polygon coordinates data, create a tool to edit the KML file to reduce the precision of the map data, for me, one digit decimal data is OK. or try to find other KML file, but normally it is very hard to find !

now my app keeps alive!

Really suggest Qlik provides more technical details for their product (error descriptions), otherwise the user would have to take much time to understand what happened and find the workarounds.....

Re: Qlik Sense Map Error: the hypercube results are too large"

robert99 — Fri, 26 Feb 2016 20:05:45 GMT

"2. the precision of the polygon coordinates data, create a tool to edit the KML file to reduce the precision of the map data, for me, one digit decimal data is OK. or try to find other KML file, but normally it is very hard to find !"

I having the same issue as you. My UK map worked up until 2.1.1. Now it no longer works. I took days to get it working as it should. So can I ask how to do this

"reduce the precision of the map data, for me, one digit decimal data is OK."

Thanks for any help on this.

"Really suggest Qlik provides more technical details for their product (error descriptions), otherwise the user would have to take much time to understand what happened and find the workarounds....."

I sometimes wonder what goes on at Qlik. Why change something that works to something that doesn't without providing a full explanation. And a work around. It almost like they have a small destructive element within Qlik. Maps are so important so why make it so hard to set them up?

Re: Qlik Sense Map Error: the hypercube results are too large"

Mon, 29 Feb 2016 07:10:24 GMT

Normally, you will find this if you open the KML file using text editor

116.426322937012,34.639991760254

when I say "the precision of the polygon data", I mean the precision of longitude and latitude data is too high. what you need to do is to replace those data with a short, simple decimal data, eg, round them to 116.42,34.63

coz there are many lines of GPS data, so you can not handle it manually. You can ask somene to write a simple scripts to read the KML file line by line to do the rounding work automatically. You can also find an altanative KML file with low data precsion.

After that, you can load the edited KML to QS , remember to use GeoAggrGeometry Function to merge polygon areas.

hope it is helpful to you!

Re: Qlik Sense Map Error: the hypercube results are too large"

robert99 — Mon, 29 Feb 2016 21:30:19 GMT

Thanks Roger

I eventually managed to solve this issue

I did a len [LEN (KML_Area)] of the KML addresses. Highland was over 1 million characters. So I simple excluded this area and it worked. Devon was 658,000 characters but was able to handle this area.

This site below had some interesting stuff on this issue

And I couldn't get GeoAggrGeometry to work. I'm working my way through "hidden gems in qlik sense geospatial functions" so hoepfully will eventually work this out as well.

What-are-some-techniques-for-minimising-the-size-of-your-KML-files

Samuel Mota, work with GIS technologies for a long time

1.2k Views • Samuel is a Most Viewed Writer in Geographic Information Systems (GIS).

Considering that you are aware that KML is not the ultimate file format for geographic data and it does have a number of downsides on storage and even on processing .... here are some techniques:

Use KMZ instead of KML - KMZ is a compressed (zip) format for KML;
If not possible to use KMZ, strip all spaces and new lines from the KML (useless if you use a compressed format)
Use Styles and BallonStyles to configure your map symbology and behavior;
Edit the file to consolidate the <STYLE> tags. Usually the Google Earth app is not very smart on reusing the tags;
Simplify the data to have less vertexes - there is a number of algorithms and tools out there. Take a look at Douglas-Peucker Algorithm for lines or the ready-to-use tool based on it: KML and Google Maps - Compression (or buy a tool like Optimize KML file size, Reduce Polygons, Coordinates, Download for polygons)
Reduce the decimal places on coordinates (of course, it'll reduce the precision - analyze your use case)

I have never used this tool, but you may want to try it: Features - KML2KML

Re: Qlik Sense Map Error: the hypercube results are too large"

robert99 — Fri, 08 Apr 2016 05:32:20 GMT

I eventually found this site for reducing the number of decimals

http://www.gearthblog.com/blog/archives/2016/03/making-kml-files-smaller-reducing-precision.html

It's free and did the job very quickly. Highland reduced from around 3 million characters to 1.5 million based on 5 decimal places. (4 distorted the map slightly or a lot with 3 or less). I also used "optimize KML file size" (US$20). It reduced the number of characters slightly for Highland but not much. But using both worked OK. That is reduce the decimal's to 5 and then run optimize.

I tried Qlik's geogetboundingbox with 15 decimal places but it still didn't work.

Re getAggrGeomentry. I tried this and it increased the number of decimals back up to 15. So instead I just grouped greater London using the visualization grouping facility. Even though it still showed the boundaries (like GetReduceGeometry).

Re: Qlik Sense Map Error: the hypercube results are too large"

NZFei — Wed, 27 Apr 2016 23:41:55 GMT

I went to that site, browse my file, set the precision and then click "Reduce Precision" but nothing happened. Have I done anything wrong?

Thanks

Fei

Re: Qlik Sense Map Error: the hypercube results are too large"

robert99 — Thu, 28 Apr 2016 05:16:18 GMT

Hi Fei

What browser are you using. Try both Firefox and Chrome But otherwise I'm unable to help

Re: Qlik Sense Map Error: the hypercube results are too large"

NZFei — Thu, 28 Apr 2016 20:32:06 GMT

Thank you very much. It works in Chrome.