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, Feb 03 '20 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, Feb 04 '20 at 09:25

score 7 · Answer 1 · answered Feb 03 '20 at 14:38

7

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

answered Feb 03 '20 at 14:38

spatialthoughts

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

Processing -> Toolbox and search for it. – spatialthoughts Feb 03 '20 at 14:49

score 3 · Accepted Answer · answered Feb 03 '20 at 14:00

3

The simplest answer is the $id variable.

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

answered Feb 03 '20 at 14:00

gisnside

2 Answers2