Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jurciello
New Contributor II

KML and Qlik Sense

Hello to everybody!

There are some useful guides from M.Taralo and others about polygon maps in QS. For example, polygon map for USA. My question is following : how can I make polygon map for Ukraine?  Does Google or some another engine have possibility to give user list of coordinates or kml file of selected area ?  Also it is interesting to know how can I see selected area that kml file describes. For example ,

<coordinates>29.6639912107,45.2126777257,0 29.5815912351,45.3871367193,0 29.2190313425,45.4258320041,0 28.7026581622,45.2204429335,0 28.3785515915,45.3019131682,0 28.2137516404,45.4490363677,0 28.5323648793,45.5301760008,0 28.4884182257,45.6651472759,0 28.9663380840,46.0068881904,0 29.0377513962,46.1941362050,0 28.9333780938,46.4301452039,0 29.2025513474,46.5439754575,0 29.2410046693,46.3693377078,0 29.4991912595,46.4832958208,0 29.8672444838,46.3465173133,0 30.0979644154,46.3807443084,0 29.9002044740,46.5363942316,0 29.9716177862,46.7407134740,0 29.8672444838,46.8614252394,0 29.5760979034,46.9480185040,0 29.5980712302,47.2780328309,0 29.4112979522,47.2892470291,0 29.1366313669,47.5502328137,0 29.2574846644,47.7654924940,0 29.1750846889,47.9540350929,0 28.9608447523,47.9466542596,0 28.8070314646,48.1271794621,0 28.2137516404,48.2080246585,0 27.7632984405,48.4497913601,0 27.5490585040,48.4680600470,0 27.2414319285,48.3693305611,0 26.7030854213,48.3400403343,0 26.6371654408,48.2557365678,0 26.3185522019,48.1749671188,0 26.1592455824,47.9835478216,0 25.3352458266,47.9171203213,0 25.1155125584,47.7580846082,0 24.9012726218,47.7173222650,0 24.5551927244,47.9540350929,0 24.2475661489,47.9023469884,0 23.5004730369,47.9835478216,0 23.1269264809,48.0903892603,0 22.8962065493,47.9540350929,0 22.7918332469,48.1161451835,0 22.6050599689,48.1161451835,0 22.1491134373,48.4132341450,0 22.1601001007,48.5775333163,0 22.3303933836,48.6867686431,0 22.5556199835,49.0780476618,0 22.8632465590,49.0022067199,0 22.7039399396,49.1681828743,0 22.7588732566,49.2869091337,0 22.6544999542,49.5306529181,0 22.7808465835,49.6734633915,0 23.3027130955,50.0993735989,0 23.7202063051,50.3847290451,0 24.0003662221,50.4128191334,0 24.1102328562,50.5670155623,0 23.9564195685,50.7903987248,0 24.1322061831,50.8391213514,0 23.6817529832,51.2891084440,0 23.6048463393,51.5261635206,0 23.7531662954,51.6527715237,0 23.9619129002,51.5843788093,0 24.2860194708,51.7415272176,0 24.3958861049,51.8845323855,0 24.9946592608,51.9117197661,0 25.1704458754,51.9592578998,0 25.8186590167,51.9354951610,0 26.4339121677,51.8573284669,0 26.9283120212,51.7517570016,0 27.2029786065,51.7517570016,0 27.2798852504,51.5980656411,0 27.8676717429,51.6220076233,0 28.0764183477,51.5638407887,0 28.6257515183,51.5638407887,0 28.7575914792,51.4163785426,0 28.8344981231,51.5501435924,0 29.1805780206,51.6185881172,0 29.3398846400,51.3717025168,0 29.6255378887,51.4918842408,0 29.7628711814,51.4404167008,0 30.2078310495,51.4850252735,0 30.5539109470,51.2512028342,0 30.6418042543,51.3682640827,0 30.5539109470,51.5432934392,0 30.6637775811,51.8233003060,0 30.9604174932,51.9999645868,0 30.9604174932,52.0778818493,0 31.7844172491,52.1083340627,0 32.1250038148,52.0440215512,0 32.3007904294,52.1083340627,0 32.3667104099,52.3175487071,0 32.9160435804,52.2467965778,0 33.2071901608,52.3781030502,0 33.5148167364,52.3276468871,0 33.8334299753,52.3646537333,0 34.0641499069,52.1961898106,0 34.1300698874,51.9863998220,0 34.3827631458,51.8437203046,0 34.3882564776,51.7142364086,0 34.1080965606,51.6732691382,0 34.3827631458,51.2649903292,0 34.7672963652,51.1718440501,0 35.0749229408,51.2201657703,0 35.1683095798,51.0577411983,0 35.3715628529,51.0404281725,0 35.4869228187,50.6788407675,0 35.4594561602,50.4864759994,0 35.6956694235,50.3460778417,0 35.8604693747,50.4303669398,0 36.1461226234,50.4233486017,0 36.2779625843,50.2933206384,0 36.6515091403,50.2193616216,0 36.8108157598,50.3144305847,0 37.4645222327,50.4373842322,0 37.7446821497,50.0817027563,0 38.0248420667,49.9046338266,0 38.1841486862,50.0640253615,0 38.6510818812,49.9578233506,0 38.9422284616,49.8122987810,0 39.2004150517,49.8726917743,0 39.2498550371,49.7731805301,0 39.5904416028,49.7197862482,0 39.8101748711,49.5521013076,0 40.1397747734,49.6021107348,0 40.0573747978,49.4734109187,0 40.1672414319,49.2509617783,0 39.9200415052,49.0491695894,0 39.7058015687,49.0347242236,0 39.8266548662,48.8247920109,0 39.6618549150,48.6030428372,0 39.8486281930,48.5556577018,0 39.9969481491,48.2960732325,0 39.7772148808,48.0241001226,0 39.7332682272,47.8173179810,0 38.8982818079,47.8690914766,0 38.7554551836,47.6913658744,0 38.3544419691,47.6097039817,0 38.2226020081,47.3415483292,0 38.2335886715,47.1095327747,0 37.5414288766,47.0795208432,0 36.7613757744,46.7520417800,0 36.6130558184,46.7746912050,0 36.1955626087,46.6651302068,0 35.9099093600,46.6500007743,0 35.3495895260,46.3503213784,0 35.2067629017,46.3883473766,0 35.0364696188,46.2513290861,0 34.7013763848,46.1750585856,0 34.5640430921,45.9877452614,0 34.4047364727,46.0145434958,0 34.5365764336,46.1826904329,0 34.3278298288,46.1712422622,0 34.1575365459,46.2818074386,0 34.1245765557,46.1177857472,0 33.9597766045,46.2132071613,0 33.6686300241,46.2170205531,0 33.8993499557,46.0375030133,0 34.3607898190,46.0145434958,0 34.3607898190,45.8842582601,0 34.6354564043,45.9379424510,0 34.4651631214,45.7690447055,0 34.6464430677,45.7844203807,0 34.9870296335,45.6304715879,0 35.0584429456,45.3639067408,0 35.3440961943,45.3329184934,0 35.0529496139,45.6111979804,0 34.7563097018,46.0107159764,0 34.8222296823,46.0719242945,0 35.0694296091,45.6343255092,0 35.4594561602,45.2980363018,0 36.1351359600,45.4567690211,0 36.6020691549,45.4180950817,0 36.2285225990,45.0065107462,0 35.8549760430,44.9870223321,0 35.5253761406,45.1194119689,0 35.1023895993,44.8074158402,0 34.7233497116,44.8074158402,0 34.4431897946,44.7056492945,0 34.3388164922,44.5487330403,0 33.9323099460,44.3795717445,0 33.7125766778,44.3953284986,0 33.3664967803,44.5840764333,0 33.5532700583,44.6233215122,0 33.6191900388,44.9168087923,0 33.5642567217,45.0882892228,0 33.2786034730,45.1544046418,0 32.9325235755,45.3445410874,0 32.5095370342,45.3406671563,0 32.5260170293,45.4567690211,0 32.9325235755,45.6574434347,0 33.7675099948,45.9264430955,0 33.5917233802,46.1559743030,0 33.4269234291,46.0451540530,0 33.1907101657,46.1597916926,0 32.5370036927,46.0757475483,0 31.7679372539,46.3084620071,0 32.0590838343,46.3921485111,0 31.6580706198,46.4719107980,0 31.7624439222,46.5515556181,0 32.3502304147,46.4605233779,0 32.4930570391,46.5742897085,0 32.1414838099,46.5591347135,0 31.9382305368,46.7633676903,0 32.0096438490,46.9254425262,0 31.8393505661,47.1807429076,0 31.9382305368,46.8538887381,0 31.9107638783,46.6537835318,0 31.1746574297,46.6272986381,0 30.8340708640,46.5477656710,0 30.7626575518,46.3807443084,0 30.2462843715,45.8727477052,0 29.9826044496,45.8420411586,0 29.7408978545,45.6227629452,0 29.6365245521,45.8190000481,0 29.6200445570,45.4876889622,0 29.7518845180,45.4490363677,0 29.6639912107,45.2126777257,0 </coordinates>

list of coordinates for Ukraine . But how can I see that on Google map . And vice versa.

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: KML and Qlik Sense

11.jpg

Download file KMZ

12.jpg
Extract the files from the archive. Showed WinRAR, but you can use any archiver - WinRAR, WinZIP, 7z, etc

13.jpg
We get a KML file
15.jpg
Open Qlik Sense, Data download Editor. Create a new connection

16.jpg
Specify the path to the file KML
17.jpg
We get a new data source

18.jpg
Select the file KML

19.jpg
Рaste script

23.jpg
Add the two fields (SumSale - model of sales data by region) and load date from KML file.
21.jpg

Next, open a new worksheet and insert a map object

22.jpg
Adding dimension Name

24.jpgin expression of map in In In expression of map object inserted Sum(SumSale)

25.jpg
We get results

26.jpg
In operating mode, the color of the region reflects the level of sales. When you hover the mouse appears the value of the region's total sales

Regards

Andrey Kh

5 Replies
ahaahaaha
Honored Contributor

Re: KML and Qlik Sense

Hi, Yuriy!

When it comes to loading the geo-coordinates in the Qlik Sense, you can do without Google map.


Geodata files in the proper format for the regions of the world, including to the Ukraine, can be downloaded at www.gadm.org. On this page, select the Ukraine and KMZ format of files. You can download geodata several levels (countries, regions, districts, etc.).

KMZ - KML is an archive file that can be extracted by any archiver (WinRAR? WinZIP, etc).

After extracting the KML files can be loaded into Qlik Sense.


Regards

Andrey Kh.

jurciello
New Contributor II

Re: KML and Qlik Sense

Thanks for answer,but have You succed with loadind KMZ directly into QS on practice?

ahaahaaha
Honored Contributor

Re: KML and Qlik Sense

11.jpg

Download file KMZ

12.jpg
Extract the files from the archive. Showed WinRAR, but you can use any archiver - WinRAR, WinZIP, 7z, etc

13.jpg
We get a KML file
15.jpg
Open Qlik Sense, Data download Editor. Create a new connection

16.jpg
Specify the path to the file KML
17.jpg
We get a new data source

18.jpg
Select the file KML

19.jpg
Рaste script

23.jpg
Add the two fields (SumSale - model of sales data by region) and load date from KML file.
21.jpg

Next, open a new worksheet and insert a map object

22.jpg
Adding dimension Name

24.jpgin expression of map in In In expression of map object inserted Sum(SumSale)

25.jpg
We get results

26.jpg
In operating mode, the color of the region reflects the level of sales. When you hover the mouse appears the value of the region's total sales

Regards

Andrey Kh

jurciello
New Contributor II

Re: KML and Qlik Sense

Thanx, for such illustrated guide. It's really works. I used GeoJSON-download from GADM-site. After that I used mapshaper.org (for open GeoJSON) ‌ and  converter.mygeodata.eu  for convert into kml. Why ? I did not  know  I could obtain kml from kmz .

ahaahaaha
Honored Contributor

Re: KML and Qlik Sense

All the best. Good luck!

Regards

Andrey Kh