Adding descending row number using QGIS

Question

I'm adding an id in QGIS with the function @row_number and it is adding the numbers descending, as you see it in the picture. But i need them exactly in the reverse order.

Without a sort order, the generated numbers should be assumed to be in a random order. For an ordered assignation, see this answer — JGH, Mar 18 '21 at 17:36

score 6 · Accepted Answer · answered Mar 18 '21 at 16:59

6

Try a formula like

TOTAL_NUMBER_OF_RECORD - @row_number

(you may adjust result by adding a -1 or +1 depending if you want to start from 0 or 1)

You may also want to have a look at the Sort and Number plugin :

This plugin adds a new field to an attribute table, where features are numbered depending on multiple sorting criteria.

answered Mar 18 '21 at 16:59

J.R

16,090
1
19
52

the plugin works fine, thx – user154532 Mar 19 '21 at 05:11

Adding descending row number using QGIS

1 Answers1