Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 (3)
1 Reply
joostvanegmond7
Partner - Contributor III
Partner - Contributor III

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?