topic Re: How to create a geomakepoint dimension when fetching lattitude and longitude from database. in Management & Governance

How to create a geomakepoint dimension when fetching lattitude and longitude from database.

laxmanqlik — Tue, 23 Aug 2016 05:42:36 GMT

How to create a geomakepoint dimension when fetching lattitude and longitude from database.

Re: How to create a geomakepoint dimension when fetching lattitude and longitude from database.

marcohadiyanto — Tue, 23 Aug 2016 08:06:14 GMT

Hi Laxman,

Let say you have this coloumn in your table.

Country

Longitude

Latitude

Are you using data manager or load editor? If you're using load editor then you should do scripting.

Connect to .... (yourdatabase)

Load Country,

Longitude,

Latitude,

Geomakepoint(Latitude, Longitude) as Point;

SQL Select * From A;

//let say this query to load data from your database, then what you should do is adding load before sql select and put geomakepoint there.

Regards,

Re: How to create a geomakepoint dimension when fetching lattitude and longitude from database.

Wed, 16 Nov 2016 17:31:24 GMT

What about Data Manager?

I have Qlik Sense Desktop and it doesn't recognize my City or State fields from my WarehouseLocation table. I'm loading data from our SQL server. I went so far as combining the Lat & Long together directly in my SQL server to see if Qlik would recognize the field as a Geo location but doesn't work. I do not want to write out a scrip like your example above because the Data Manager doesn't allow me to make associations with tables done through Load Scrip Editor. Is there a way to force Load Manager to recognize a specific field as GeoLocation but not have to use Load Editor Scrip to do so?