Qlik Sense Map

[#1]

Hi, I'm creating a map using Qlik Sense, following some instruction videos on Qlik Sense, but strangely after I load my data with lat and long, I still have no dimensions available to create the map when I click the "Add Dimension" button. Please see a screen shot that I added here.

What did I miss here? Thanks for help!

X

my data:

screen shot:

[#2]

You're probably missing your GeoMakePoint

Check here. Fast-forward to about 6:30

Video Link : 2031

This was made when maps were beta, but the same concepts apply

[#3 · Accepted solution]

Use this

make changes in Script Editor, add this line next to your lat and long.

GeoMakePoint(lat, long) as 'Location',

Drag the 'Location' from fields.

Select the URL background.

[JonnyPoole]

After you add the geomakepoint() expression to the load editor script , reload the script .

Then you will have to manually add a URL to a 'slippy map server' . Its not obvious how to do this but its easy.

Hit the link below (its a product help link) , scroll down to 'Adding a Background Map' and you will see a list of URLs you can use to add the map.  The maps look pretty good

http://help.qlik.com/sense/en-US/online/#../Subsystems/WorkingWith/Content/Visualizations/Map/Map.ht...

[#5]

Hi. I´ve got a problem loading Lat and Long:

By loading data this Way:

LOAD *, GeoMakePoint(Latitude, Longitude) as Location;

LOAD
    CityID,
    AccentCity,
    Latitude,
    Longitude,
    Population
FROM [lib://Desktop/Cities.csv]
(txt, utf8, embedded labels, delimiter is ',', msq)

Location field is null

You know What the problem is?

Thank you

[#6]

Write GEOMAKEPOINT statement in load statement. try this

LOAD

    CityID,

    AccentCity,

    Latitude,

    Longitude,

     GeoMakePoint(Latitude, Longitude) as Location,

    Population

FROM [lib://Desktop/Cities.csv]

(txt, utf8, embedded labels, delimiter is ',', msq)

[#7]

Hi. I´ve  tried with the following statement:

LOAD

    CityID,
    AccentCity,
    Latitude,
    Longitude,
    GeoMakePoint(Latitude, Longitude) as Location,
    Population
FROM [lib://Desktop/Cities.csv]
(txt, utf8, embedded labels, delimiter is ',', msq) ;

and it doesn´t work, Location is still null  

[#8]

Can you upload Cities.csv for us to give it a shot?

[#9]

Of course !!! 

This is a sample of the data:

http://community.qlik.com/docs/DOC-7286

Thank you  

[#10]

Hi,

Based on data which u have given, I've got the output perfectly.

Steps u have to follow:

1) Upload the data into Data Editor (csv file with correct delimiters)

2) Make changes in the script(check the screen shot of data editor)

3) Create map with 'Location' field as dimension.

4) Copy the URL from web and paste it in background tab URL input box. (check the screenshot)