Qgis 2.8 filtering the ten most populated places for a specified altitude

Question

I try to filter data combining settlement and altitudes. I try to filter the 10 most populated places for a specified altitude.

I tried this expression without success:

"altitude">1000 AND ORDER BY POPULATION DESC LIMIT 10

wiltomap · Accepted Answer · 2016-01-21 11:01:14Z

2

In Field Calculator, try only to enter this:
```
"altitude">1000
```
Then, display the attributes table and choose to display only selected features:

Sort the population column by clicking on the column title (once for ASC sorting and twice for DESC sorting)

answered Jan 21, 2016 at 11:01

wiltomap

2,6902 gold badges22 silver badges51 bronze badges

Thank you for your answer. It does not exist a way to combine the two operations in an SQL expression?
– Wilcar
Jan 21, 2016 at 11:03
The SQL expressions in QGIS use the [WHERE](www.w3schools.com/sql/sql_where.asp) clause for filtering. I do not think they Query Builder allows for filtering x amount of rows as that operation tends to use the SELECT clause. If you import your layer into PostGIS which uses SQL, you should be able to filter out the top 10 rows. But this answer was also the first method to pop into my mind =)
– Joseph
Jan 21, 2016 at 12:00

Add a comment |

1 Answer 1