How to create KML file?

[rupaliqlik]

Hello Experts,

               Please help to me create Contrywise KML file ?I want to create KML file For Mexico ,Brazil and Argentina Country.

Means all the states inside Brazil,Mexico and Argentina country.When I select Mexico country it should highlight area map inside mexico country.Like Which states have good performance they should highlight by green color and others as red color.I am not able to  create a KML file.Please please help me .I am stuck in my project as I have old version of qliksense and not have permission to upgrade the qliksense version.I know in april 2018 release qliksense has added new feature Multi layer area map but I can not use that and instead of that I have to achieve same result.so Please help me .

Regards,

Rupali Ethape

stalwar1‌jagan‌

Message was edited by: RUPALI ETHAPE

[bwisealiahmad]

Hi,

As Peter mentioned above you can do this with QGIS. I've done something similar for Norway through this site:

https :// wambachers-osm.website/boundaries/

Lets you chose between only land or water and you can choose which level you would like it on. Country level, region level or all the way down to next level after region.

That being said since you have 3 countries it would take some time to export it all. If you do go through with it you have to

1. Export it as .json.
2. Rename the format from .geojson to .json
3. Convert from .json to KML.
4. Connect this info to your QlikSense datamodel.

It's a way, but not the easiest

Best,

Ali A

[rupaliqlik]

Will it give me the output like Regions inside Mexico,Argentina and Brazil?

[rupaliqlik]

Hi,

It is giving me only country wise data. I tried this for India.Is is showing Only India map.What about states inside India map.

Regards,

Rupali

[bwisealiahmad]

Hi,

Yes it will. See below for example of the 4 regions of Brazil.

[rupaliqlik]

Hi Ali,

When I create QVD for Mexico KML and load into qliksense then it gives  "hypercube results are too large" message in  qlik sense map.the Procedure was toll lengthy.

Regards,

Rupali

[bwisealiahmad]

Hi,

You could share your QVD, but once again.

1) Go to that site and export the country you want with regions.

2) Rename it from .GeoJson to .Json

3) Use a converter somewhere that does .Json-> .KML(like this one: https://geoconverter.hsr.ch/)

4) Load this into QlikSense it will work.

Added an example I just made for Brazil.

Best,

Ali A

[rupaliqlik]

Hi  All ,

           Thank you so much all of you.I have found solution and it is working now finely with your help.I have prepared document and

I have attached with this.Please look into it .

Regards,

kaushik.solanki‌shraddha.g‌ @bwisealiahmad @petter-s

[bwisealiahmad]

Uhm,

You are doing some other steps then what I did because I didn't get that hyper cube error, but if it works then it should be fine.

Mark the correct response correct so that it is easier for the next person that is looking for the answer.

Best,

Ali A