How to use Geo Operations connection Dissolve operation in Qliksense

[lakshman1031]

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

[Lisa_P]

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/GeoOperationsFunctio... 

[lakshman1031]

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

[lakshman1031]

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

[Lisa_P]

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.

[lakshman1031]

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