Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dberkesacn
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
dberkesacn
Contributor III

Re: Qlik Sense Map Geo Points

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

31 Replies
dmac1971
Contributor II

Re: Qlik Sense Map Geo Points

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
Contributor III

Re: Qlik Sense Map Geo Points

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

ahaahaaha
Honored Contributor

Re: Qlik Sense Map Geo Points

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
Contributor III

Re: Qlik Sense Map Geo Points

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
Valued Contributor

Re: Qlik Sense Map Geo Points

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
Valued Contributor

Re: Qlik Sense Map Geo Points

nop

dberkesacn
Contributor III

Re: Qlik Sense Map Geo Points

dmac1971
Contributor II

Re: Qlik Sense Map Geo Points

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

dberkesacn
Contributor III

Re: Qlik Sense Map Geo Points

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

thanks for your help.