Qlik Community

Ask a Question

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

cancel
Showing results for 
Search instead for 
Did you mean: 
dynamic_girl
Creator
Creator

dissolve function in qlikview

has someone used a dissolve function in geomap in qlikview,

how to implement the same,

3 Replies
Patric_Nordstrom
Employee
Employee

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
Specialist
Specialist

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
Employee
Employee

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