If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
This post is in regards to using an KML file to load Map onto an Qlik Sense dashboard.
Although i was successful in loading an World Map from a KML file by mapping it using CountryName from my DB(SQL).
But, the outcome is rather slow and even consumes more than a minute only to load the map.
Could any one please suggest an alternate or best way on this approach.
How big is the KML file ? It may have a lot more details than really required. Consider processing the file in something like qGIS to remove detail and reload the less granular KML into SENSE:
To reduce the complexity of a KML file, you can do this for free with qGIS: http://www.qgis.org/en/site/
Thanks for the suggestion and sorry for the delayed response.
I'm basically trying to load an World Map from KML, could you please suggest on how to figure out the non-required stuff.
The reason for the performance issue could be that you are trying to plot a kml file which has multitude number of polygons. As you might be having data only for a few countries in world map, I would suggest you to follow this.
Just plot the polygons which have data or measures associated to it and make use of the background property in the properties panel.
And the output would be some thing like this:
Though you are not plotting the entire world map using the polygon data, you happen to visualize all the information required.
Hope this helps you resolve your issue.
Thanks for the quick response. As in the image below i have only been considering countries which have presence in my data.
And also turning the background is making the map show up more then once.
My suggestion above was to decrease the precision of the polygons. That will reduce the files size considerably and allow it work faster in Qlik Sense.
I'm not clear if you followed the steps above or not. Did you follow them ? Or are you asking for alternatives ?
An alternative, which i think could be less effective, is as follows:
<other KML Fields>
from <KML file>
This would only load the country polygons from for the countries that exist in your main data sets. This will introduce holes in gaps in the map, but with the technique mentioned by Sangram you could fill those by turning on the map background.