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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ravi05
Contributor II
Contributor II

I have ploygon data coming from snowflake but not able to plot on area map

Hi Champ,

 

I have dataset in ploygon like , I need to plot this in Area Map

ID | Geometry

1 |   POLYGON ((32.5511860889073077 29.7998000000000012, 32.5503343630507729 29.8066138068523365, 32.5500140396132025 29.8094967177904948, 32.5480846898328267 29.8474744450462346, 32.5493973618182935 29.8583338223804908, 32.5579139683624774 29.8696469265959124, 32.5613861327090675 29.8706389735520759, 32.5899077215101727 29.8650022959233965, 32.5923157883390786 29.8613901956800412, 32.5865244905703264 29.8200862229142132, 32.5782217761809463 29.8115496292462687, 32.5676996884398164 29.8014801044187401, 32.5560589649671428 29.7998000000000012, 32.5511860889073077 29.7998000000000012))

 

 

 

ravi05_0-1695820378921.png

 

Labels (4)
1 Solution

Accepted Solutions
ravi05
Contributor II
Contributor II
Author

I have solved this using past references.

='[[['& replace(

     replace(

        replace(replace(GEOMETRY,'POLYGON((',''),'))','')          

            ,', ','],[')

        ,' ',',')

& ']]]'

 

Thanks

 

View solution in original post

3 Replies
ravi05
Contributor II
Contributor II
Author

@Patric_Nordstrom , Hey Patric 

I am using Qlik SaaS / Qlik cloud, Will you able to help me out here?

ravi05
Contributor II
Contributor II
Author

I have solved this using past references.

='[[['& replace(

     replace(

        replace(replace(GEOMETRY,'POLYGON((',''),'))','')          

            ,', ','],[')

        ,' ',',')

& ']]]'

 

Thanks

 

Patric_Nordstrom
Employee
Employee

Load with GeoOperations, will convert from WKT automatically.

https://help.qlik.com/en-US/cloud-services/Subsystems/Sense_GeoOperations/Content/Sense_GeoOperation...

 

Thanks,

Patric