I've an attribute column named e.g. VALUE
with different values I would like to make a column named e.g. ORDER
such that the greatest value has the attribute 1
the second value 2
etc. etc. so order express the order from the biggest to the smallest value like this:
VALUE ORDER
12000 1
8000 2
600 3
500 4
200 5
So far I've tried with QGIS 1.8 to order the VALUE
column (that please note is not in the right order by default) from max
to min
simply clicking over the attribute name and than use $rownum
in field calculator but this seems use the default rows numeration so I don't have the right order.
Please edit my question if you think you can explain it better!