topic How to dissolve point layer in Qliksense in App Development

How to dissolve point layer in Qliksense

lakshman1031 — Thu, 20 Feb 2025 12:29:26 GMT

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

Re: How to dissolve point layer in Qliksense

David_Friend — Thu, 20 Feb 2025 13:54:14 GMT

@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

Re: How to dissolve point layer in Qliksense

lakshman1031 — Thu, 20 Feb 2025 15:44:22 GMT

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

Re: How to dissolve point layer in Qliksense

mikaelsc — Thu, 20 Feb 2025 17:30:14 GMT

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

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