Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Geometry Functions not working

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

1 Reply
Anonymous
Not applicable
Author

Hey. I have same problem now. Have you managed to solve it?