Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Qlik Sense Map

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.

20 Replies
Not applicable

Re: Qlik Sense Map

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

Re: Qlik Sense Map

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.

Employee
Employee

Re: Qlik Sense Map

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

Re: Qlik Sense Map

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

Re: Qlik Sense Map

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

Re: Qlik Sense Map

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

Re: Qlik Sense Map

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

Not applicable

Re: Qlik Sense Map

Of course !!! 

This is a sample of the data:

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

Thank you  

Not applicable

Re: Qlik Sense Map

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

Community Browser