Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
klewandowski
New Contributor III

Re: Geometry Functions not working

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