Im joining dots with a CSV file and map my data with proportional circles. Unfortunately I have some overlapping.

How do I sort a join layer based on attribute column called aPOPCLA72 ?

  • Filtering virtual layer of my layer based on 1=1 order by "aPOPCLA72" desc do not work. The column is not sorted.

  • Sorting using MMQGIS gives me invalid sort field name error (field name: aPOPCLA72)

Why I want to sort my data: avoiding proportional circles overlapping. I want to render the big circles first.

enter image description here

I am using QGIS 3.6

  • the suggestion below to use the 'control feature rendering order' will only work if your data is NOT joined, that is, if you export your joined datasets into a static one... I've been having this issue lately. Jun 12, 2019 at 15:48

1 Answer 1


Try controlling drawing order within symbology menu:


Note this is just a workaround to get your visual result. It will not change the sort order of attributes. Only the order in which your features will be drawn.

  • Thank you forhelping. Not working with the size assistant ?
    – Wilcar
    Jun 12, 2019 at 10:50
  • Not sure if I get you right. But you can not control drawing or attribute order using size assistant.
    – MrXsquared
    Jun 12, 2019 at 10:52
  • It should actually work like you tried with virtual layer. E.g. select * from pointlayername order by "aPOPCLA72 " desc. Can't tell why it does not from here...
    – MrXsquared
    Jun 12, 2019 at 10:53
  • OK. It is why I want to sort my column before to ovoid overlapping. The size asssistant is great for rendering proportional symbols.
    – Wilcar
    Jun 12, 2019 at 10:54
  • Ah ok. Yes sure, use the renderer like you already did. Just leave everything as it is and do the step in my answer as additional step.
    – MrXsquared
    Jun 12, 2019 at 10:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.