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: 
Not applicable

Qlik Sense Map

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:

2014-10-09_1215_Map_Data.png

screen shot:

2014-10-09_1214_Qlik_Sense_Map.png

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

21 Replies
Not applicable
Author

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

Not applicable
Author

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
Employee
Employee

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...

Not applicable
Author

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

NULL.PNG.png

You know What the problem is?

Thank you

Not applicable
Author

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)

Not applicable
Author

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  

Not applicable
Author

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

Not applicable
Author

Of course !!! 

This is a sample of the data:

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

Thank you  

Not applicable
Author

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)

Capture.JPG.jpg1.jpg