topic Geometry Functions not working in App Development https://community.qlik.com/t5/App-Development/Geometry-Functions-not-working/m-p/1005168#M14864 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using Qlik Sense Geo functions on my SQL Server 'geometry' data type but Qlik Sense is not able to detect the geometry.</P><P></P><P>Following is data sample:</P><P>myGeoID (Int) = 1</P><P>myPolygonName (varchar) = X</P><P>myPolygon (geometry) =</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="108"><TBODY><TR><TD height="19" style="border: 0px black; border-image: none;" width="108"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E610000001040B000000D122DBF97E925D4070CE88D2DED033C01F85EB51B8965D402AA913D0443834C021B0726891A55D40D656EC2FBB6734C03F355EBA49AC5D40711B0DE02D5034C0105839B4C8A65D403333333333C333C0931804560E9D5D40BA490C022BC733C00000000000A05D40273108AC1C1A34C004560E2DB29D5D40EA95B20C711C34C0DF4F8D976E9A5D400EBE30992AC833C0D122DBF97E925D4070CE88D2DED033C0D122DBF97E925D4070CE88D2DED033C001000000020000000001000000FFFFFFFF0000000003</SPAN></TD></TR></TBODY></TABLE><P></P><P>But if I use GeoAggrGeometry(myPolygon) function in the Load statement, Qlik Sense gives me following error:</P><P></P><P>The following error occurred:</P><P class="edc_error">Invalid expression</P><P></P><P>Can you please guide?</P><P></P><P>Thanks,</P><P>Nish</P></BODY></HTML> Thu, 27 Aug 2015 07:52:19 GMT 2015-08-27T07:52:19Z Geometry Functions not working https://community.qlik.com/t5/App-Development/Geometry-Functions-not-working/m-p/1005168#M14864 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using Qlik Sense Geo functions on my SQL Server 'geometry' data type but Qlik Sense is not able to detect the geometry.</P><P></P><P>Following is data sample:</P><P>myGeoID (Int) = 1</P><P>myPolygonName (varchar) = X</P><P>myPolygon (geometry) =</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="108"><TBODY><TR><TD height="19" style="border: 0px black; border-image: none;" width="108"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">E610000001040B000000D122DBF97E925D4070CE88D2DED033C01F85EB51B8965D402AA913D0443834C021B0726891A55D40D656EC2FBB6734C03F355EBA49AC5D40711B0DE02D5034C0105839B4C8A65D403333333333C333C0931804560E9D5D40BA490C022BC733C00000000000A05D40273108AC1C1A34C004560E2DB29D5D40EA95B20C711C34C0DF4F8D976E9A5D400EBE30992AC833C0D122DBF97E925D4070CE88D2DED033C0D122DBF97E925D4070CE88D2DED033C001000000020000000001000000FFFFFFFF0000000003</SPAN></TD></TR></TBODY></TABLE><P></P><P>But if I use GeoAggrGeometry(myPolygon) function in the Load statement, Qlik Sense gives me following error:</P><P></P><P>The following error occurred:</P><P class="edc_error">Invalid expression</P><P></P><P>Can you please guide?</P><P></P><P>Thanks,</P><P>Nish</P></BODY></HTML> Thu, 27 Aug 2015 07:52:19 GMT https://community.qlik.com/t5/App-Development/Geometry-Functions-not-working/m-p/1005168#M14864 2015-08-27T07:52:19Z Re: Geometry Functions not working https://community.qlik.com/t5/App-Development/Geometry-Functions-not-working/m-p/1005169#M14865 <HTML><HEAD></HEAD><BODY><P>Hey. I have same problem now. Have you managed to solve it? </P></BODY></HTML> Mon, 22 Aug 2016 08:03:28 GMT https://community.qlik.com/t5/App-Development/Geometry-Functions-not-working/m-p/1005169#M14865 Anonymous 2016-08-22T08:03:28Z