Hi All,
I am using Qlik Sense Geo functions on my SQL Server 'geometry' data type but Qlik Sense is not able to detect the geometry.
Following is data sample:
myGeoID (Int) = 1
myPolygonName (varchar) = X
myPolygon (geometry) =
| E610000001040B000000D122DBF97E925D4070CE88D2DED033C01F85EB51B8965D402AA913D0443834C021B0726891A55D40D656EC2FBB6734C03F355EBA49AC5D40711B0DE02D5034C0105839B4C8A65D403333333333C333C0931804560E9D5D40BA490C022BC733C00000000000A05D40273108AC1C1A34C004560E2DB29D5D40EA95B20C711C34C0DF4F8D976E9A5D400EBE30992AC833C0D122DBF97E925D4070CE88D2DED033C0D122DBF97E925D4070CE88D2DED033C001000000020000000001000000FFFFFFFF0000000003 |
But if I use GeoAggrGeometry(myPolygon) function in the Load statement, Qlik Sense gives me following error:
The following error occurred:
Invalid expression
Can you please guide?
Thanks,
Nish
