My problem is quite hard to explain, I have attached some images to help illustrate my issue.
I want to produce a large number of maps which overlap in geographic area. Currently my data is arranged as shown in image 1.
I have a number of sites in each column, which colour UK wards based on differing values.
I want to set up a system in QGIS which will map Site 1, and then move along the colons to map site 2 and so on.
Unfortunately each ward is affected by multiple sites. Ward E050001 may have a value for site 1 of 0.75, and then a value of 0.25 for site 2 etc.
I currently manually change the values to move along the columns in the layer properties as shown in image 2, and it's this manual step that prevents me from using a QGIS Atlas.
If Image 3 was my map, I'd like it to display the area around site 1, export a map, and then move on to site 2 and export a map. This is a simplification however, as the areas often overlap for sites, and I'd like the colour to vary based on the value in the cells shown in image one.
I feel the best way would be to use an Atlas and a bit of python to move each column along as it moves to the next item in the Atlas, but an unsure how to do this or if it would even work.
Does anybody have any idea how I would go about achieving this?
It's trivial to do manually, but I have potentially thousands of maps that I need to do!