How to dissolve point layer in Qliksense

[lakshman1031]

Hi All,

I have zip code and i am trying to create point layer map.

If I select region then it will filter out the data and showing the points.

If regions having central, then having 3 zip codes and then it is showing 3 points in Map.

My Requirement is to show dissolve all 3 points area and show the sales data.

Can you please suggest me how to do. if possible, can you please share example qvf file.

Thanks & Regards,

Lakshman

[David_Friend]

@lakshman1031 can you provide an illustration of what you are wanting to accomplish?

Also have you watched our video: https://help.qlik.com/en-US/video/5G1N9SAic4asPUz71knFv1

[lakshman1031]

Hi David,

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

[mikaelsc]

maybe a combination of geoaggrgeometry https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Geospatial... to aggr different locations into 1 shape. 

and https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Geospatial... to get it's center?