Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
SamuelHaag
Contributor III
Contributor III

Use Function GeoAggrGeometry() to aggregate postcodeareas

Hi guys,

I'm trying to aggregate postcode areas to a several sales areas. This is what have in the script so far:

[MapSource]:
LOAD
"Postcode",
"Sales-Region",
FROM [----]
(ooxml, embedded labels, table is UP5);


Map:
LOAD "Sales-Region",
GeoAggrGeometry("Postcode") as [Aggr]
resident MapSource Group By "Sales-Region";


drop Table MapSource;

 

The table [MapSource] is looking like that:

PostcodeSales-Region
01067B1
01069B1
01097B2
01099B2
01108B3
01109B3
........

 

Unfortunately the field [Agrr] is empty after the load. 

 

Maybe you can help me

Thank you!

Regards

 

Samuel

Labels (1)
0 Replies