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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
matthieu-hoffmann
Partner - Contributor III
Partner - Contributor III

GeoAggrGeometry utilization

Hello everyone,

I'm trying today to regroup some areas I have on my map using GeoAggrGeometry() but have some difficulties.

I'd like my map to display the 

Here is the script I imlplemented :

D_INSTITUTION :
LOAD *
FROM $(vPathLookUp)D_INSTITUTION.qvd](qvd);

left join (D_INSTITUTION)
LOAD * INLINE [
LB_TERRITORY, ZONE, ZONES
Centre-Est,Auvergne-Rhône-Alpes,Z1,
Centre-Est,Bourgogne-France-Compté,Z1
Centre-Est,Grand-Est,Z1
IdfEst,Essonne,Z2,
IdfEst,Paris,Z2,
IdfEst,Seine-et-Marne,Z2,
IdfEst,Seine-Saint-Denis,Z2,
IdfEst,Val-de-Marne,Z2,
IdfOuest,Yvelines,Z3,
IdfOuest,Val-d'Oise,Z3,
IdfOuest,Hauts-de-Seine,Z3,
Nord-Ouest,Hauts-de-France,Z4,
Nord-Ouest,Bretagne,Z4,
Nord-Ouest,Normandie,Z4,
Nord-Ouest,Pays de la Loire,Z4,
Nord-Ouest,Centre-Val de Loire,Z4,
Sud-Ouest,Occitanie,Z5,
Sud-Ouest,Nouvelle-Aquitaine,Z5,
Sud-Est,Corse,Z6,
Sud-Est,Provence-Alpes-Côte d'Azur,Z6,
];

NoConcatenate
Map:
LOAD LB_TERRITORY,
GeoAggrGeometry(ZONES) as [AggrArea]
resident D_INSTITUTION Group By LB_TERRITORY;

 

as thus :

matthieu-hoffmann_0-1603383755906.png

can someone could help me please ?

www.easyneo.fr
Labels (1)
0 Replies