dissolve function in qlikview

[Anonymous]

has someone used a dissolve function in geomap in qlikview,

how to implement the same,

[Patric_Nordstrom]

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

[rupamjyotidas]

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

[Patric_Nordstrom]

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-operat...

Thanks,
Patric