Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-09-18 01:07 PM

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.

1,117 Views
0 Likes
1 Reply
Not applicable
‎2017-09-21 05:09 PM
Author

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.

840 Views
0 Likes