0

I have multiple grids in my project file. I am utilizing Atlas to automatically print all grids. I was successful yet I have added "SEE SHEETS A1..." within the sides of the mapview as required by our client. What I think now to solve this is similar to Dynamic Text. Yet I wasn't able to figure it out.

The output is should be like this: enter image description here

PolyGeo
  • 65,136
  • 29
  • 109
  • 338

1 Answers1

3

This can be done with the aggregate function in expressions:

for example the northern neighbour:

aggregate(layer:='your_grid_layer',
          aggregate:='concatenate',
          expression:='See sheet ' || "fieldname_with_sheet_nr",
          filter:=intersects($geometry, geometry(@parent))
                  AND x_max($geometry)=x_max(geometry(@parent))
                  AND y_max($geometry)>y_max(geometry(@parent)),
          concatenator:='')
eurojam
  • 10,762
  • 1
  • 13
  • 27
  • This worked for me very well. It fits what I need. Its just that the prerequisite knowledge is that you know how expressions works in the Layout Manager. Thanks a lot. – Suzuha Amane Jul 13 '23 at 00:47