Dissolve

[chhavi376]

Hi all,

I am using the below file and i want to dissolve 'D' on the basis of zip codes.

I used the following script:

Zipcodes:

LOAD

    ZIP,  

    GeoMakePoint(LAT,LNG) as GeoInfo,

    D

FROM [lib://AttachedFiles/US Zip Codes from 2013 Government Data.xlsx]

(ooxml, embedded labels, table is [US Zip Codes from 2013 Governme]);

TAG FIELD [ZIP] WITH '$geoname', '$relates_Zipcodes.GeoInfo' ;

TAG FIELD [Zipcodes.GeoInfo] WITH '$geopoint', '$hidden', '$relates_ZIP' ;

And the settings i have used are:

this isnt working fine. I am not abl to plot East, Middle and West region on the map.

Can anyone help?

[ignacio_pena]

Hello Chhavi,

The dissolve function only works with AREA's geometries (polygons) does not work with Points. You would have to generate the geometries of the ZIP CODES to then apply the Dissolve.

According to the help:

"Dissolves and simplifies areas to form larger areas based on a mapping between old area identities (or geometries) and new area identities."

https://bi.idevio.com/wp-content/qlik/geoanalytics/releases/IdevioGeoAnalyticsConnector-5.10.5/doc/g...

Greetings,