Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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