Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Qliksense Map

Hi,

I need to build a Map in Qliksense for the below cities.Please find the attachment.

For these cities which KML File I need to consider and I don't have the latitude and longitude fields.

Also is it possible to put the drill down in qliksense map.I need to put City and Postal code in the map Drill down.

Please help me to do.

Thanks,

2 Replies
tinaco110
Contributor III

Re: Qliksense Map

Hi Bhavvi,

I will get you started, first, I took a couple of cities from your list: Worcester and Milford, then I gots its coordinates from Google Map, the solution file (attached) perform an INLINE load for these to cities, the columns on this inline load are: City, Patients, Latitude, Longitude, then within the same INLINE load a created a new colum using QlikSense's function GeoMakePoint, I named this table: Data_Sample. Once I loaded this data, on the User Interface I dragged a map component, and because the Data_Sample contains a GeoMakePoint, it allowed me to define the map.

Please see the attachment, and select the MAP sheet.

NOTE: I used this solution to help somebody else, that's why you will find other stuff in the application.

NOTE 2: You do not need a KML file at all.

Hope this helps,

lironbaram
Honored Contributor II

Re: Qliksense Map

hi

there is no drill down capabilities, in the map

you'll need an extension mapping

starting from version 3.1 you don't need kml file

qlik sense should create the geo point automatically

Community Browser