Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Country | Sales |
French | 100 |
Italy | 150 |
Spain | 200 |
qvf is attached.
thanks,
Daniel
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.
So those points can't be generated from just the country code?
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
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
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.
nop
Have you seen that video from Qlik ?
Qlik Sense 3.1 - Understanding Geographic Data Profiling - YouTube
Apologies Daniel, see what you mean, let me investigate.
no problem, the previous guys also did the same .. haha .
thanks for your help.