11 Replies Latest reply: Apr 28, 2016 4:32 PM by Fei Xu RSS

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

    Roger SHEN

      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"
          Sangram Reddy

          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.

           

          Capture.jpg

           

          Thanks and Regards,

          Sangram Reddy.

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

              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"
                  Sangram Reddy

                  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"
                Roger SHEN

                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"
                  Robert Hutchings

                  "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?