Maps in qlik sense

[pascos88]

Good morning

I m learning about use of Maps in qlik sense.

I load simple data with this code:

[Mapdata]:

Load

[Company] AS c,

CountryName,

CountryCode,

Number,

Latitude,

Longitude,

GeoMakePoint(Latitude,Longitude) as Location

FROM [lib://../MapsDataTest.xlsx]

(ooxml, embedded labels, table is Sheet1)

;

Trace ***** SkriptEnde *****;

Exit Script;

Now of course the result that I have is with Point but I would have different color for the country based on the sum(Numner). see the picture attached.

I have maybe to load the data in different way, someone have a suggestion?

Thanks for any helps

[agigliotti]

I suggest you to take a look at Qlik Sense Mapping and County KML

[YoussefBelloum · Accepted solution]

Hi,

First thing you should know: you can't use points and areas (what you're trying to color) on the same map.

Latitude and longitude with Geomakepoints() ==> points on Map

KML file ==> Areas that you can color using an expression for example.

here is one document dedicated to maps on qliksense: Geographic 'Drill Down' (Areas and Points) for US MAP

take a look