GeoAggrGeometry can be used to aggregate a number of areas into a larger area. I have used GeoAggrGeometry in combination with group by. So you can aggregate the areas.
How can I explain the function of GeoAggrGeometry in a simple way? Well, I have created two KML-files and each file includes two polygons. The polygons in the first KML-file overlap and the polygons in the second KML-file are appropriate. When the polygons are appropriate you can’t see any problem in Qlik Sense but when the polygons overlap you will see an error of the depiction.
Hi guys, good to know that you're able to manipulate the GeoAggrGeometry() function with Qliksense.
On my side I have been trying to use this function sometimes with success and sometimes without.
I was able to create different maps with different levels of aggregation, let say Department/Region/Super Region and suddenly I am not able to reload the app anymore and it's like killing the machine I am working on.
I am including the piece of script I use and I thought you guys could probably see what's going wrong there. FYI I am trying to load different tables GeoPoint1, GeoPoint2, GeoPoint3, I could also chose to join them but I haven't done it yet.
Hope you can help.
Thanks very much.
GeoAggrGeometry_Script.txt 976 bytes
Ok sorry guys, in fact the script had a small issue and I could load correctly my different aggregated areas.
Thanks Robert for your explanation on your blog, it was really useful.
Now I would like to know if it's possible to build a Drill Down Group using the areas that we display in the Map. So that we can actually Drill Down by clicking on a particular area in the Map.
If you guys know a trick please share.