Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
peachman
Contributor III
Contributor III

Qlik Sense - Hexagon Gridded Map

Hey,

Been searching for a while, and cannot find anything about this topic, I am looking to see if the following is possible with the Qlik Sense Geoanaytics?

 

A picture below of a map split by Hexagons, with various sizes, Is something like this even possible to create within Qlik? The idea being we would like to have various sixed hexagons  based on density so each hexagon represents the same amount of something (eg. Population , houses, roads by length, any measure) We further discussed this idea with the data we have available that we could colour the hexagons, based on something to see if we can spot trends in the data that we have. 

peachman_0-1643016736505.png

 

Labels (3)
1 Reply
Patric_Nordstrom
Employee
Employee

Sure, can be done using the GeoOperations method "Binning", support for hex and rect bins.

Ref doc: https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoOperationsService/Content/connector/connector... Examples: https://community.qlik.com/t5/Documents/GeoOperations-Examples-Qlik-GeoAnalytics/ta-p/1753980

I recommend using rectangular binning instead as the hexagonal bins don't stack well on top of each other. Here's an example with distribution of airports in France, note the gridSize parameter. Colored by level.

Patric_Nordstrom_0-1643032785429.png

hex:
Load BinId,BinTable.BinPolygon,ap.Name, 1 as lvl Extension GeoOperations.ScriptEval('
  Binning(type="hexagonal", gridSize="1")
  DATASOURCE ap LOCATIONSERVICE geometry="POINT", type="AIRPORTIATA", country="fr"
');
Load BinId,BinTable.BinPolygon,ap.Name, 2 as lvl Extension GeoOperations.ScriptEval('
  Binning(type="hexagonal", gridSize="0.5")
  DATASOURCE ap LOCATIONSERVICE geometry="POINT", type="AIRPORTIATA", country="fr"
');
Load BinId,BinTable.BinPolygon,ap.Name, 3 as lvl Extension GeoOperations.ScriptEval('
  Binning(type="hexagonal", gridSize="0.25")
  DATASOURCE ap LOCATIONSERVICE geometry="POINT", type="AIRPORTIATA", country="fr"
');

Thanks,

Patric

 

 

Thanks.