Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marco_puccetti
Partner - Creator
Partner - Creator

KML and Geolocation

Hello! i need to obtain an Italy Map that contains for each region the amount of IMPORT field.

This is the Table structure:

NDGTIPO_PAGCITTAPROVINCIAABIDATA INCASSOIMPORTOLATITUDELONGITUDE
1223456COPisaPI516407/04/201520.000,0043.71613510.3966024

When i attach these data to the map the region linking is not done, but the Sum(IMPORTO) is linked to every region.

I have also used this statement to have a correct coordinate linking:

LOAD

    NDG,

    TIPO_PAG,

    CITTA,

    PROVINCIA,

    ABI,

    "DATA INCASSO",

    IMPORTO,

    LATITUDE,

    LONGITUDE,

    GeoMakePoint(LATITUDE,LONGITUDE) AS LOCATION

FROM [lib://Downloads/GEOMAPS.xlsx]

(ooxml, embedded labels, table is Foglio1);

What have i to do to render for each region (City) with circles the amount of data?

Is it necessary to mantain a certain table structure to obtain this?

Thanks

6 Replies
JonnyPoole
Employee
Employee

it looks right...a few things to check:

1. did you add 'LOCATION' as the dimension for the map ?

2. after #1, did you drag IMPORTO into the same map ? when you do this it should prompt you to select sum,avg, min etc...

3. then just make sure the background / show property on the right is set to 'ON'

I would suggest doing steps 1-3 after dragging in a brand new map object onto the dashboard. its trickier to change an existing map.

marco_puccetti
Partner - Creator
Partner - Creator
Author

Ok, I've noticed that some KML's map i have found were corrupted or not properly formed, so i ask you if you let me have some maps (in KML format) I can use for Italy Region and Province locations.

Thanks

Not applicable

Hi Marco,

take a look at Welcome to the QGIS project!.

Regards,

Przemek

marco_puccetti
Partner - Creator
Partner - Creator
Author

Thanks!!

Marco

Not applicable

Hi Marco,

did you finally got the KML file? I'm looking for the same

Best regards,

Davide

marco_puccetti
Partner - Creator
Partner - Creator
Author

Try here: kmlfactbook.org