Mixing
Weighted values of the field in QGIS
Clash Royale CLAN TAG#URR8PPP
up vote
1
down vote
favorite
In QGIS in the Attribute Table, there is a field with values.
For this field, I need to calculate the sum of all its values and divide by the number of values that are not equal to NULL.
Afterwards, I need to create a new field, where each value of the original field will be divided into the previously calculated (the sum of all its values and divided by the number of values).
Is it possible to do this with the function editor in the Field Calculator (as this action will be repeated more than once)?
qgis field-calculator
edited 3 hours ago
Taras
1,3081521
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
1
down vote
favorite
In QGIS in the Attribute Table, there is a field with values.
For this field, I need to calculate the sum of all its values and divide by the number of values that are not equal to NULL.
Afterwards, I need to create a new field, where each value of the original field will be divided into the previously calculated (the sum of all its values and divided by the number of values).
Is it possible to do this with the function editor in the Field Calculator (as this action will be repeated more than once)?
qgis field-calculator
edited 3 hours ago
Taras
1,3081521
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
it would be highly appreciated if you can provide us with a sample of your data and your desired output, alternatively you may describe it. For instance, my values are integers or real, and my output should look like something.
– Taras
3 hours ago
add a comment |Â
up vote
1
down vote
favorite
up vote
1
down vote
favorite
In QGIS in the Attribute Table, there is a field with values.
For this field, I need to calculate the sum of all its values and divide by the number of values that are not equal to NULL.
Afterwards, I need to create a new field, where each value of the original field will be divided into the previously calculated (the sum of all its values and divided by the number of values).
Is it possible to do this with the function editor in the Field Calculator (as this action will be repeated more than once)?
qgis field-calculator
edited 3 hours ago
Taras
1,3081521
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
In QGIS in the Attribute Table, there is a field with values.
For this field, I need to calculate the sum of all its values and divide by the number of values that are not equal to NULL.
Afterwards, I need to create a new field, where each value of the original field will be divided into the previously calculated (the sum of all its values and divided by the number of values).
Is it possible to do this with the function editor in the Field Calculator (as this action will be repeated more than once)?
qgis field-calculator
qgis field-calculator
edited 3 hours ago
Taras
1,3081521
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 3 hours ago
Taras
1,3081521
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 3 hours ago
Taras
1,3081521
edited 3 hours ago
Taras
1,3081521
edited 3 hours ago
Taras
1,3081521
1,3081521
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
asked 4 hours ago
Õúðтõрøýð ãòðрþòð
91
91
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Õúðтõрøýð ãòðрþòð is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
it would be highly appreciated if you can provide us with a sample of your data and your desired output, alternatively you may describe it. For instance, my values are integers or real, and my output should look like something.
– Taras
3 hours ago
add a comment |Â
it would be highly appreciated if you can provide us with a sample of your data and your desired output, alternatively you may describe it. For instance, my values are integers or real, and my output should look like something.
– Taras
3 hours ago
it would be highly appreciated if you can provide us with a sample of your data and your desired output, alternatively you may describe it. For instance, my values are integers or real, and my output should look like something.
– Taras
3 hours ago
it would be highly appreciated if you can provide us with a sample of your data and your desired output, alternatively you may describe it. For instance, my values are integers or real, and my output should look like something.
– Taras
3 hours ago
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
4
down vote
First of all, you need to create one additional field in the Attribute Table:
"Output", where the calculated new values will be stored (probably a real data type).
Then you need to proceed in Expression dialogue using the following formula
CASE
WHEN "YOUR_FIELD" <> 'NULL' THEN "YOUR_FIELD" / (sum("YOUR_FIELD") / count("YOUR_FIELD"))
ELSE NULL
END
A short example. I do have a field with values, that vary between 3 and 300, and also include 'NULL' values. See the Attribute Table below.
In my case, the sum of all values is 544. The number of values that are not equal to 'NULL' is 7.
Then I proceed with a formula in the Expression dialogue with activated Editing mode.
CASE
WHEN "Value" <> 'NULL' THEN "Value" / (sum("Value") / count("Value"))
ELSE NULL
END
Afterwards, I achieved corresponding new values.
References:
- Summarizing column in QGIS field calculator?
- Calculating sum of parts of column based on another column using QGIS Field Calculator?
- How to group and count attribute data?
- Elseif Conditional Statement in QGIS Field Calculator
answered 3 hours ago
Taras
1,3081521
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
4
down vote
First of all, you need to create one additional field in the Attribute Table:
"Output", where the calculated new values will be stored (probably a real data type).
Then you need to proceed in Expression dialogue using the following formula
CASE
WHEN "YOUR_FIELD" <> 'NULL' THEN "YOUR_FIELD" / (sum("YOUR_FIELD") / count("YOUR_FIELD"))
ELSE NULL
END
A short example. I do have a field with values, that vary between 3 and 300, and also include 'NULL' values. See the Attribute Table below.
In my case, the sum of all values is 544. The number of values that are not equal to 'NULL' is 7.
Then I proceed with a formula in the Expression dialogue with activated Editing mode.
CASE
WHEN "Value" <> 'NULL' THEN "Value" / (sum("Value") / count("Value"))
ELSE NULL
END
Afterwards, I achieved corresponding new values.
References:
- Summarizing column in QGIS field calculator?
- Calculating sum of parts of column based on another column using QGIS Field Calculator?
- How to group and count attribute data?
- Elseif Conditional Statement in QGIS Field Calculator
answered 3 hours ago
Taras
1,3081521
add a comment |Â
up vote
4
down vote
First of all, you need to create one additional field in the Attribute Table:
"Output", where the calculated new values will be stored (probably a real data type).
Then you need to proceed in Expression dialogue using the following formula
CASE
WHEN "YOUR_FIELD" <> 'NULL' THEN "YOUR_FIELD" / (sum("YOUR_FIELD") / count("YOUR_FIELD"))
ELSE NULL
END
A short example. I do have a field with values, that vary between 3 and 300, and also include 'NULL' values. See the Attribute Table below.
In my case, the sum of all values is 544. The number of values that are not equal to 'NULL' is 7.
Then I proceed with a formula in the Expression dialogue with activated Editing mode.
CASE
WHEN "Value" <> 'NULL' THEN "Value" / (sum("Value") / count("Value"))
ELSE NULL
END
Afterwards, I achieved corresponding new values.
References:
- Summarizing column in QGIS field calculator?
- Calculating sum of parts of column based on another column using QGIS Field Calculator?
- How to group and count attribute data?
- Elseif Conditional Statement in QGIS Field Calculator
answered 3 hours ago
Taras
1,3081521
add a comment |Â
up vote
4
down vote
up vote
4
down vote
First of all, you need to create one additional field in the Attribute Table:
"Output", where the calculated new values will be stored (probably a real data type).
Then you need to proceed in Expression dialogue using the following formula
CASE
WHEN "YOUR_FIELD" <> 'NULL' THEN "YOUR_FIELD" / (sum("YOUR_FIELD") / count("YOUR_FIELD"))
ELSE NULL
END
A short example. I do have a field with values, that vary between 3 and 300, and also include 'NULL' values. See the Attribute Table below.
In my case, the sum of all values is 544. The number of values that are not equal to 'NULL' is 7.
Then I proceed with a formula in the Expression dialogue with activated Editing mode.
CASE
WHEN "Value" <> 'NULL' THEN "Value" / (sum("Value") / count("Value"))
ELSE NULL
END
Afterwards, I achieved corresponding new values.
References:
- Summarizing column in QGIS field calculator?
- Calculating sum of parts of column based on another column using QGIS Field Calculator?
- How to group and count attribute data?
- Elseif Conditional Statement in QGIS Field Calculator
answered 3 hours ago
Taras
1,3081521
First of all, you need to create one additional field in the Attribute Table:
"Output", where the calculated new values will be stored (probably a real data type).
Then you need to proceed in Expression dialogue using the following formula
CASE
WHEN "YOUR_FIELD" <> 'NULL' THEN "YOUR_FIELD" / (sum("YOUR_FIELD") / count("YOUR_FIELD"))
ELSE NULL
END
A short example. I do have a field with values, that vary between 3 and 300, and also include 'NULL' values. See the Attribute Table below.
In my case, the sum of all values is 544. The number of values that are not equal to 'NULL' is 7.
Then I proceed with a formula in the Expression dialogue with activated Editing mode.
CASE
WHEN "Value" <> 'NULL' THEN "Value" / (sum("Value") / count("Value"))
ELSE NULL
END
Afterwards, I achieved corresponding new values.
References:
- Summarizing column in QGIS field calculator?
- Calculating sum of parts of column based on another column using QGIS Field Calculator?
- How to group and count attribute data?
- Elseif Conditional Statement in QGIS Field Calculator
answered 3 hours ago
Taras
1,3081521
edited 2 hours ago
answered 3 hours ago
Taras
1,3081521
answered 3 hours ago
Taras
1,3081521
answered 3 hours ago
Taras
1,3081521
1,3081521
add a comment |Â
add a comment |Â
Õúðтõрøýð ãòðрþòð is a new contributor. Be nice, and check out our Code of Conduct.
Õúðтõрøýð ãòðрþòð is a new contributor. Be nice, and check out our Code of Conduct.
Õúðтõрøýð ãòðрþòð is a new contributor. Be nice, and check out our Code of Conduct.
Õúðтõрøýð ãòðрþòð is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f301639%2fweighted-values-of-the-field-in-qgis%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
it would be highly appreciated if you can provide us with a sample of your data and your desired output, alternatively you may describe it. For instance, my values are integers or real, and my output should look like something.
– Taras
3 hours ago