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:
qvf is attached.
Solved! Go to Solution.
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.
You can see the geo icon below Sheet1 icon, and the fact that only two column were loaded Country name and sales.
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.
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.
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.
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.