topic Re: dissolve function in qlikview in GeoAnalytics

dissolve function in qlikview

Anonymous — Thu, 27 Sep 2018 07:39:11 GMT

has someone used a dissolve function in geomap in qlikview,

how to implement the same,

Re: dissolve function in qlikview

Patric_Nordstrom — Fri, 28 Sep 2018 11:53:27 GMT

Check out the "Dissolve Guide" at

https://bi.idevio.com/products/idevio-maps-for-qlik-sense/qlik-sense-2

and the "Dissolve Example" at

https://bi.idevio.com/geoanalytics/geoanalytics-connector-examples

Although the examples are made with Qlik Sense the load script code will work in QlikView too.

Thanks,

Patric

Re: dissolve function in qlikview

rupamjyotidas — Tue, 26 Mar 2019 21:51:16 GMT

Getting the below error when using Dissolve

Connector reply error: QVX_SYNTAX_ERROR: *Failed to process query: Failed to create dataset DissolveDef: com.idevio.geoanalytics.g.y: The location service responded with error: 500, Internal Server Error - Too many items in location lookup

Re: dissolve function in qlikview

Patric_Nordstrom — Sun, 31 Mar 2019 10:58:37 GMT

There is a upper limit on the number of location lookups that can be made in a single call, 20K when towards maps.qlikcloud.com, 50K with QGA Plus.

Try install QGA Plus or make the operation in several steps, for instance do NameAreaLookup first and after that Dissolve.
https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Splitting-up-GeoAnalytics-connector-operations/ta-p/1520571

Thanks,
Patric