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: 
dberkesacn
Partner - Creator III
Partner - Creator III

Qlik Sense Map Geo Points

Hi,

I have seen this video Qlik Sense 3.1 - Understanding Geographic Data Profiling - YouTube from @Michael Tarallo

It says that Sense automatically generates geo points. I have tried this function with my Sense Desktop (3.1 SR6 latest version), but I haven't found any geo points after the data loading process.

My data is the following read from xlsx:

 

CountrySales
French100
Italy150
Spain200

qvf is attached.

thanks,

Daniel

1 Solution

Accepted Solutions
dberkesacn
Partner - Creator III
Partner - Creator III
Author

Ok, it seems that I solved my question after 2 days.

So if you click on prepare data during the load it'll works just based on COUNTRY NAME but if you click on that screen load and finish or directly load your xls it wont work.

Here you have to click on Prepare data.

HaveToClickOnPrepareData.jpg

You can see the geo icon below Sheet1 icon, and the fact that only two column were loaded Country name and sales.

working.jpg

View solution in original post

31 Replies
dmac1971
Creator III
Creator III

Daniel you need a longitude and latitude data point for each country, you then combine these using code as follows for example :

GeoMakePoint(Latitude, Longitude) as 'Location'

Location is then the dimension used in the map.

dberkesacn
Partner - Creator III
Partner - Creator III
Author

So those points can't be generated from just the country code?

ahaahaaha
Partner - Master
Partner - Master

Hi Daniel,


A small example in the attached file. There are only two countries, the third one is no longer fit - in Qlik Sense the limitation of the number of hypercubes in the construction of maps.

It is necessary to take the original KML files and reduce their accuracy by deleting part of the polygons.

I also attach KML files for the three countries mentioned.

Regards,

Andrey

dberkesacn
Partner - Creator III
Partner - Creator III
Author

Thanks,

my original question was, based on that video Qlik can generate qeo points automatically from Country Name.

why have not generated it in my case?

Could you pls check that vid, it is 5 min long.

Daniel

zebhashmi
Specialist
Specialist

If you have two fields with name of Latitude, Longitude QS make Geopoint automatically. else you will make a geo point with Geomakepoint. it do not pick from name. 

zebhashmi
Specialist
Specialist

nop

dberkesacn
Partner - Creator III
Partner - Creator III
Author

dmac1971
Creator III
Creator III

Apologies Daniel, see what you mean, let me investigate.

dberkesacn
Partner - Creator III
Partner - Creator III
Author

no problem, the previous guys also did the same .. haha  .

thanks for your help.