8 Replies Latest reply: Oct 27, 2016 11:37 AM by Michael Tarallo RSS

    Qlik Sense Map is Currently Showing Limited Data Set

    Eric Garbin

      Hello Qlik Community,

      I'm experimenting with the Map chart that comes with Qlik Sense Server 2.2 on Windows Server 2012 R2.  I have a CSV file of latitude-longitude pairs.  The Map chart shows only 1935 of my over 10,000 points.  There is also a footnote *Currently showing a limited data set.

       

      From this forum, I see that Qlik Sense used to be able to render no more than 1000 points in a Map.  Despite the interest in overcoming this, I haven't found any record that the limit can be exceeded as of 2016.  I also didn't find anything in the server manuals, but this may be due partly to not knowing what the problem is.   I have heard a rumor there is a server setting now that will allow me to map all the points. But no documentation alas.

       

      I've tried reconfiguring the Qlik Sense Engine to allow it more memory, but this hasn't helped.  I wonder whether there's some throttle on the requests that the Engine can make to the Mapbox API?

        • Re: Qlik Sense Map is Currently Showing Limited Data Set
          Ricardo Gerhard

          Hi Eric,

           

             I´ve a ticket open on Qlik Support about it. I recommend you do it also.

             In my tests, we discover that QS FR 2.2.4 have more points been showed instead of QS SR209.

           

          Regards.

          • Re: Qlik Sense Map is Currently Showing Limited Data Set
            Johan Persson

            Hi,

             

            Internally Qlik transfers data in pages and I think that the Sense map is limited to read one page. In IdevioMaps (http://bi.idevio.com) we read multiple pages and can therefor in theory handle any number of points. However there are several reasons that you should not try to load too many points. I would not recommend to display more than 10000 points at a time. The limit for acceptable display performance is somewhere between 20000 and 50000 points but it seldom makes sense to display that many since the map will be too crowded. The image below shows a map with about 10000 points and it is not easy to make something out of it (even if a crowded visualization also passes a message).

            bubbles.png

            The solution to this in IdevioMaps is normally to switch presentation in different scales and show aggregated data when zoomed out. Data can be aggregated in several ways, binning can group data in rectangles or hexagons, clustering can group data together that is close or data could be related to existing areas such as postal areas or zip areas.

             

            One way is then to do drill-down hierarchies that could show something like countries when you are zoomed out. Then, when you select a country it will drill down to the next aggregation level and finally to the actual points.

             

            Also, in IdevioMaps we can load data as you pan. If you have a dataset with millions of points you can pan around in the data when you are zoomed in and IdevioMap will load data as you pan. You then let the scale control the visualization so that an appropriate aggregated level is presented when you zoom out.

              • Re: Qlik Sense Map is Currently Showing Limited Data Set
                Ricardo Gerhard

                Hi Johan,

                 

                   I believe in a exibithion limitation as you mentioned, but the number isn´t 10000. We did some tests around 2k polygons and the issue happens. But it change sometimes and theresn´t a clear understanding.

                   The situation is:

                - Why in QS FR 2.2.4, like Erik mentioned, this situation happens different?

                - If there is a limit, where´s this numbers on product or a help talking about it?

                   My suggestion is open a case to understand and help to getting better the product to all users.

                 

                Regards

                Ricardo Gerhard

              • Re: Qlik Sense Map is Currently Showing Limited Data Set
                Aleksandra Siwierska

                Hi,

                I've got the same problem. I wanted to upload a zip-code map of Poland (there is 20473 objects) and I've blank spaces. Is there any solution for that? Or there are no possibilities to upload the whole map?