topic Re: How to use Geo Operations connection Dissolve operation in Qliksense in App Development

How to use Geo Operations connection Dissolve operation in Qliksense

lakshman1031 — Sun, 16 Feb 2025 10:37:39 GMT

Hi All,

I have create Qlik Geo operation connection and i am trying to use Dissolve operation.

My Source is excel file, I am trying to use dissolve in Geo operation connection, here i didn't see the tables.

Can you please suggest me how to map these excel file into geo operation connection.

If not possible to connect the excel file using geo operation connection, Please suggest me how to add data into geo operation connection in Qliksense cloud.

Thanks & Regards,

Lakshman

Re: How to use Geo Operations connection Dissolve operation in Qliksense

Lisa_P — Mon, 17 Feb 2025 02:17:06 GMT

Help has good examples to follow. Here is example for Dissolve operation in Qlik Cloud:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Global_Common/GeoOperationsFunctions/GeoOperations-Dissolve-Example.htm

Re: How to use Geo Operations connection Dissolve operation in Qliksense

lakshman1031 — Mon, 17 Feb 2025 13:12:49 GMT

Hi Lisa,

Thank you for your replay.

I am trying to setup the Qlik Geo Operation connection like below way.

Step 3:

I am getting error.

Can you please suggest me how to use dissolve operation in Qlik geo operation connection.

Thanks & Regards,

Lakshman

Re: How to use Geo Operations connection Dissolve operation in Qliksense

lakshman1031 — Mon, 17 Feb 2025 17:01:18 GMT

Hi Lisa,

I followed same steps and i am trying to refresh the data then i am getting error like

Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'GEOOPS-401: Missing column in indata: [zip_code]'

Can you please suggest me how to use dissolve operation in Qlik GeoOperation Connection in Qliksense.

Thanks & Regards,

Lakshman

Re: How to use Geo Operations connection Dissolve operation in Qliksense

Lisa_P — Mon, 17 Feb 2025 22:53:00 GMT

It appears that you are trying to dissolve points, not areas ?

Such as from this:

Create this:

Points cannot be dissolved, it must be areas.

Re: How to use Geo Operations connection Dissolve operation in Qliksense

lakshman1031 — Tue, 18 Feb 2025 16:20:44 GMT

Hi Lisa,

Thank you for your replay.

I have two tables Like

Hirarchy
team_id	level1_geoname	level2_geoname	level3_geoname	zip_code
RM	Total US	East	Central	30293
RM	Total US	East	Central	41824
RM	Total US	East	Central	47547
RM	Total US	East	Florida	33317
RM	Total US	West	Great Lakes	46711
RM	Total US	West	Great Lakes	44305
RM	Total US	West	Great Plains	64153

Date Table:

Data
level3_geoname	Sales
Great Plains	100
Central	200
Pacific West	300
New England	150

Output:

I want to show data like above images in Map.

For example level3_geoname field values Central having 3 zip codes and these codes forming a triangle shape and showing sales data. same way in each level3_geoname i want to show forming shape and show the Sales data.

I am using Geo Operation Connection and here Operation is Dissolve mode , Dissolve filed is level3_geoname , Key field is level3_geoname and Geometry type and field is ZipCode.

Finally, I got DissolveResultTable and insert the script and load the data.

But it's not workout, can you please suggest me what things we need to require to creating dissolve mapping.

My Requirement is if central having 3 zip codes, these zip codes having to form outline shape and show sales data.

Can you please suggest me how to do.

Thanks & Regards,

Lakshman