I have two columns in QGIS attribute table:

column A = street name
column B = Building type [Residential or Commercial]

what I am trying to do is get "street name" with the highest number of "Commercial" Building Type.

closed as off-topic by Andre Silva, Midavalo, Mapperz Apr 30 '16 at 21:23

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking help to debug/write/improve code must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Providing a clear problem statement and evidence of a code attempt will help others to help you. See: How to create a Minimal, Complete, and Verifiable example." – Andre Silva, Midavalo, Mapperz
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Welcome to gis.stackexchange! Please note that a good question on this site is expected to show some degree of research on your part, i.e. what you have tried and - if applicable - code so far. For more info, you can check our faq. – underdark Apr 30 '16 at 19:24
  • Don't think this is possible to do in the attribute table. You may need to use the GroupStats plugin to calculate the Count for each "street name", export the results as a csv and then do a Join with the shapefile and the csv file. – Joseph May 3 '16 at 10:59

Browse other questions tagged or ask your own question.