Adding unique ID automatically in Field calculator as counter in QGIS 3

Question

I tried a lot by Field Calculator but it gives me NULL as you show in table and another try it gives me value 1 in all rows.

Most of examples, on internet they are explaining old version and I have QGIS 3 and I am not sure how can I add id for all rows .

If I want to generate random id, how can I do it also.

I did as suggested in answer $id

But could i ask why the values are not looks like counter, it looks random. If i need to increase by one, how can i do that?

Does this answer your question? Filling column with consecutive numbers in QGIS? — gisnside, Commented Feb 3, 2020 at 13:58
You should try to order your "q" column to check if the randomness-like view is not caused by another column. — gisnside, Commented Feb 4, 2020 at 9:25

spatialthoughts · Accepted Answer · 2020-02-03 14:38:36Z

8

The easiest and preferred way is to use the processing algorithm "Add Autoincremental Field"

answered Feb 3, 2020 at 14:38

spatialthoughts

6,17129 silver badges49 bronze badges

where can i fnd it ,i looked for it but i did not know,where is it located
– potter90
Commented Feb 3, 2020 at 14:46
3

Processing -> Toolbox and search for it.
– spatialthoughts
Commented Feb 3, 2020 at 14:49

Add a comment |

gisnside · Accepted Answer · 2020-02-03 14:00:16Z

3

The simplest answer is the $id variable.

Be careful though, it doesn't auto-increment after your first field calculation.

answered Feb 3, 2020 at 14:00

gisnside

7,8882 gold badges32 silver badges74 bronze badges

Add a comment |

2 Answers 2