Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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 (3)
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