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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Riccardo
Partner - Creator III
Partner - Creator III

Show Polygon from JSON datapoints

Hello,

on Qlik Sense SaaS, using map, I would like to show an Area Layer starting from a loaded table.

Inside that table I have a field in json format, example below. I know and tested that it works if I read just the "datapoint" value. Can you please advice me how to do it in the best way in terms of performance?

Thanks

 

Example:

{"srid": 8307, "polygon": {"boundary": [{"line": {"datapoints": [[9.15400176264417, 39.2396489192261], [9.15258671288043, 39.2397315540535], [9.15202945615046, 39.2395674494144], [9.15123396866847, 39.2393107757624], [9.15042907140063, 39.2390761974842], [9.14990815840157, 39.2388780654762], [9.14940630153381, 39.2387388103137], [9.14880035048657, 39.2385996851204], [9.14816574512316, 39.238335422997], [9.14774900198362, 39.238166601259], [9.14717096524396, 39.2377991811492], [9.14685827567236, 39.2376081366899], [9.14621402186929, 39.2372481575394], [9.14583509574321, 39.2370571928181], [9.14574031046969, 39.2369836812054], [9.14560771944284, 39.2369323052843], [9.14540868685423, 39.2367852933274], [9.14510553105153, 39.2366236839871], [9.14467912757415, 39.2363517817391], [9.14456535719649, 39.2362488407695], [9.14430010331042, 39.2361092713943], [9.14364626096021, 39.2356756599748], [9.14278385056757, 39.2350508620932], [9.14222442865919, 39.23450668321], [9.14216730553063, 39.2343374045634], [9.14198721278277, 39.2341903635884], [9.14192077827257, 39.2340947255841], [9.14123813194298, 39.2334402463725], [9.14047003772188, 39.2326386061385], [9.14013798854391, 39.2322119516003], [9.13995746016989, 39.2318440191537], [9.13984355561274, 39.2316674439281], [9.13978651460497, 39.2315349786318], [9.13957714404979, 39.2309388281505], [9.13951983781032, 39.2306738297571], [9.13956652734715, 39.2303645300023], [9.13946162985523, 39.2299596918733], [9.13940457616421, 39.2298198633833], [9.139527450514, 39.2297534508147], [9.13960295492546, 39.2296576426021], [9.13944149305508, 39.2293559530686], [9.13950648479036, 39.2287373871844], [9.13960998912693, 39.2284501087088], [9.13963650932021, 39.2275223439848], [9.13961607571201, 39.2267713460503], [9.139605888684, 39.2264105729358], [9.1396241754268, 39.2260939437475], [9.13971745838283, 39.2254311660343], [9.13981084337022, 39.2248199288284], [9.1398951065133, 39.2243780505849], [9.14007273455609, 39.2233175717874], [9.14011040130702, 39.2232291712801], [9.14009131547412, 39.2231482013898], [9.14034367410079, 39.2216164029219], [9.14075818354537, 39.2207397139532], [9.14121949278161, 39.2196199892556], [9.14166219653598, 39.2186622704649], [9.14220975244373, 39.2180946607156], [9.14281422885822, 39.2176079720045], [9.14294656960743, 39.2175562704017], [9.14336202558522, 39.217165527149], [9.14376818413947, 39.2168557864908], [9.1440895776569, 39.2167302226123], [9.14433562360082, 39.2167667357231], [9.14444928575028, 39.2168328628908], [9.14442989072947, 39.2166046346211], [9.14506378016035, 39.2166259432543], [9.14523426644961, 39.2167214514161], [9.14547080635598, 39.2167358849556], [9.14555590339859, 39.2167136907366], [9.14579256686615, 39.2167870272226], [9.14587758662196, 39.2167280180196], [9.14612333944616, 39.2166246313002], [9.14706886055292, 39.2163804744677], [9.14716343256135, 39.2163656301994], [9.14754161084218, 39.2162547117256], [9.14774012072348, 39.2161808327759], [9.14784423087877, 39.2162027908109], [9.14833618183052, 39.2162095341298], [9.14844973679149, 39.2162241167374], [9.14856326034254, 39.2162239733401], [9.14864863906184, 39.2163343099186], [9.14863965083895, 39.2165552102718], [9.14862080883069, 39.2165920489239], [9.14931263109647, 39.2171581205799], [9.14943590131092, 39.2172904972943], [9.14965391912278, 39.217489019952], [9.15024124717175, 39.2178490558709], [9.15052560426379, 39.2180990327471], [9.15079065914378, 39.2181723225875], [9.15097080918171, 39.218356165338], [9.15129306137671, 39.2186281804607], [9.151406861195, 39.2187532042191], [9.15166990819379, 39.2187841462915], [9.1525492279919, 39.2269467113574], [9.15294727659555, 39.2303297814324], [9.15336624159456, 39.2338568027348], [9.15378592114467, 39.2376877814676], [9.15400176264417, 39.2396489192261]]}}]}}

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence
Labels (4)
1 Reply
joostvanegmond7
Partner - Creator
Partner - Creator

What do you want exactly? You want to pick out the datapoint and save it into a new field? Or is the performance for end-users just bad?