Problem with a map graph (read KML)

[dmpilars]

Hi people!!!!

I'm trying to paint a map in Qlik Sense Desktop... I generated a KML with QGIS (the original archive format is .shp). When Qlik reads them (KML) no have problems but when I try to paint a graph (dimension: INTENTO1.Area) the process never ends. I also tried transforming the KML to QVD, it failed again.

Anyone can help me? I attached the original kml and the .shp archive.

Thanks!!!

If somebody have a KML with all departments of Colombia, I would appreciate it if you would provide them.

[Quy_Nguyen · Accepted solution]

Hi,

I tried this file: MUNICIPIOSDECOLOMBIAKMLQGIS.kml

and my PC is really slow. It hit a large a mount of CPU to render the map.

For a test you can limit First 100 row in the load script and see if you can create a layer or not.

I suggest creating a drill down area like: Department -> Municipalities , based on your country's subdivisions.

You can find Colombia KMZ here: https://gadm.org/download_country_v3.html

Download KMZ file and convert it to KML by Google Earth.

[Michael_TP]

Hi,

Maybe you could try making the file smaller by reducing precision then try generating the map again.

Using this tool i managed to reduce your file size (MUNICIPIOSDECOLOMBIAKMLQGIS.kml ) from the original 169MB to 107MB.

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

I did this in one of our projects and it reduced the time needed to paint the maps.