1 Reply Latest reply: Aug 22, 2016 4:03 AM by Kamil Lewandowski RSS

    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