Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Using spatial data from adventureworks database

Hello! I am new to Qliksense and I am practicing app development concepts on MS SQL Server's Adventureworks database. In one specific table, the Address table, there is a column which has Spatial Location data. The data is in the following format, Dallas - 0xE6100000010C10A810D1886240403A0F0653663158C0. The data is of the geography datatype and is said to represent latitude and longitude information of given address. I am trying to create a map and a GeoKey as a dimension, but GeoMakePoint() function takes latitude and longitude as a tuple and not in this format. Please help.

Tags (1)
1 Reply
Not applicable

Re: Using spatial data from adventureworks database

Hello All! I figured out the solution myself. Just use the method [Columnname].Lat and [Columnname].Long on the geography datatype to extract the Latitude and Longitude values from column values. Store these values in separate columns during data load and use them as GeoKey.