Discussion board where members can get started with Qlik Sense.
I have below question from my management team..I am new to integrating Qliksense with SQL DB.If there is any sample queries that you all can point me to that would be great.
Is it possible for Qlik to run SQL Spatial functions? In particular, can we run ST.Distance, STBuffer, and STWithin queries?
Should be possible. I just ran the following:
LIB CONNECT TO '<connection namne>';
DECLARE @g geography
DECLARE @h geography
SET @g = geography:TGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326)
SET @h = geography:TGeomFromText('POINT(-122.34900 47.65100)', 4326)
SELECT @g.STDistance(@h) AS ColumnName;
Had to provide a column name. The value of ColumnName = 555.94977427173.
Hope this helps!
Thank you very much Michael.I will give this a try.