All Questions
15 questions
5
votes
2
answers
316
views
Deleting special characters from QGIS Attribute table
Is there a way to delete special characters such as *?
I've tried using replace and regexp_replace, but my version at least doesn't recognise special characters.
There are hundreds of fields, and I'm ...
- 157
4
votes
2
answers
675
views
QGIS: expression in attribute table between greater than and less than with different categories in one field
I am trying to create a field that shows the following different categories in the same field:
Variable = verschil bouwhoogte
"Verschil bouwhoogte" <3
"Verschil bouwhoogte" =>...
- 43
1
vote
1
answer
92
views
Writing degrees Celsius in short hand ('c) in QGIS expression
There is a way to add something before the ' to indicate to QGIS that it is a string and not a column. In expression builder I simply want
"temperature" || ''C'
- 495
7
votes
1
answer
209
views
Auto incremental field filled with filtered by other field value in QGIS Attribute Form
From a point geometry layer with two categories "A" and "B", when I enter new points, I first choose the category of the "CATEG" field with a listbox, and then I use the ...
- 2,676
4
votes
1
answer
727
views
Using get_feature function with attribute in QGIS
I am trying to wrap a get_feature with an attribute expression to perform the equivalent of a VLOOKUP in Excel. Using the form below I get a NULL result.
attribute(get_feature('pointst', 'when', ...
- 2,002
2
votes
0
answers
137
views
Returning field value based on expression on another field using QGIS expression
I want to return the value from one field ("Number") for the feature with the most recent timestamp ("Time") from within the current layer ('mylayer'). Or what's the number of the ...
- 2,002
2
votes
1
answer
322
views
Concatenating field names if value is true using QGIS expression
I have multiple boolean fields. I want to create a new string field, that is concatenating the field names of my existing fields when their value is true. I want the names separated by a comma.
I am ...
- 727
7
votes
3
answers
437
views
Using all columns to find the minimum with QGIS expression
I want to use aggregating functions (min, max, mean, ...) on all the attributes (= columns) within a row. In this topic Finding the minimum value of different columns in QGIS, this is done by calling ...
- 2,554
5
votes
2
answers
216
views
Converting multiple fields with abbreviations to one field with full names in QGIS
I have a field with singular abbreviations ("BB", "BC", and "BG") that corresponds to a table with full names (catfish, rainbow trout). It ranges from 1-10 abbreviations ...
- 61
4
votes
2
answers
298
views
Filling several columns based on conditions from column in QGIS
I've got two additional columns that need to be filled with attributes that are based on values created in the field.
For example, if column "reproduction" = A2 then the value in the value ...
- 71
5
votes
4
answers
2k
views
Removing unwanted data in the cell of the QGIS Attribute table
How can I remove remove data after any special character in the cell using QGIS?
E.g.: Valli Amman Mandir, Chettiyakotai
I want only Valli Amman Mandir in the cell. The rest should be removed.
- 849
2
votes
1
answer
98
views
Setting value to default otherwise counting if it is NULL with QGIS expression
I am looking to expand on this expression, I currently have the ability to count up following putting a tree no in, so I put in 'T001' then the formula counts on.
However I want to put 'T001' as ...
2
votes
1
answer
95
views
Filling in missing attribute data based on other features using QGIS expression
I have a survey form and some features (trees) will be grouped using the same "TreeNumber".
Hopefully, I can write an expression that means users only have to fill in most of the data for ...
- 2,002
2
votes
1
answer
268
views
How can I transform a StringList to one String
I have a column in Qgis with type:"StringList" eg
{ "name": "William", "height": "1.87", "age": 90 }, { "name": "Mary", &...
- 23
1
vote
1
answer
217
views
Creating new field considering duplicate and numeric values in QGIS
I'd like to create a new field considering duplicate and numeric values.
For example, I have an attribute table with duplicate values in the "field1" and numeric values in the "field2&...
- 995