QGIS 3.4.4 sorts numerical values as text, solution?
I'm trying to sort my numerical values in my attribute table but instead of getting 1, 2, 3 I get 1, 10, 100, 100 etc. When searching for a solution here on Stack Exchange, many people with earlier versions just had to update to a later one, 2.18 e.g. However, I still have this problem for my 3.4.4 version. How can I solve this bug?
qgis-3 sorting
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
add a comment |
I'm trying to sort my numerical values in my attribute table but instead of getting 1, 2, 3 I get 1, 10, 100, 100 etc. When searching for a solution here on Stack Exchange, many people with earlier versions just had to update to a later one, 2.18 e.g. However, I still have this problem for my 3.4.4 version. How can I solve this bug?
qgis-3 sorting
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
1
where did your data come from?
– Ian Turton♦
Feb 20 at 10:52
4
What is the field type of the field containing the values?
– Joseph
Feb 20 at 10:55
add a comment |
I'm trying to sort my numerical values in my attribute table but instead of getting 1, 2, 3 I get 1, 10, 100, 100 etc. When searching for a solution here on Stack Exchange, many people with earlier versions just had to update to a later one, 2.18 e.g. However, I still have this problem for my 3.4.4 version. How can I solve this bug?
qgis-3 sorting
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
I'm trying to sort my numerical values in my attribute table but instead of getting 1, 2, 3 I get 1, 10, 100, 100 etc. When searching for a solution here on Stack Exchange, many people with earlier versions just had to update to a later one, 2.18 e.g. However, I still have this problem for my 3.4.4 version. How can I solve this bug?
qgis-3 sorting
qgis-3 sorting
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
asked Feb 20 at 10:45
Felix Althén BergmanFelix Althén Bergman
111
111
1
where did your data come from?
– Ian Turton♦
Feb 20 at 10:52
4
What is the field type of the field containing the values?
– Joseph
Feb 20 at 10:55
add a comment |
1
where did your data come from?
– Ian Turton♦
Feb 20 at 10:52
4
What is the field type of the field containing the values?
– Joseph
Feb 20 at 10:55
1
1
where did your data come from?
– Ian Turton♦
Feb 20 at 10:52
where did your data come from?
– Ian Turton♦
Feb 20 at 10:52
4
4
What is the field type of the field containing the values?
– Joseph
Feb 20 at 10:55
What is the field type of the field containing the values?
– Joseph
Feb 20 at 10:55
add a comment |
1 Answer
1
active
oldest
votes
It sounds like the field's data type is Text. So it's sorting the numbers alphabetically.
Create a new field and populate it using the field calculator with
to_int("Your_Field")
The new field should sort numerically.
Bear in mind that this will only work for features which do not have any actually text characters in them.
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
1
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f312899%2fqgis-3-4-4-sorts-numerical-values-as-text-solution%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It sounds like the field's data type is Text. So it's sorting the numbers alphabetically.
Create a new field and populate it using the field calculator with
to_int("Your_Field")
The new field should sort numerically.
Bear in mind that this will only work for features which do not have any actually text characters in them.
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
1
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
add a comment |
It sounds like the field's data type is Text. So it's sorting the numbers alphabetically.
Create a new field and populate it using the field calculator with
to_int("Your_Field")
The new field should sort numerically.
Bear in mind that this will only work for features which do not have any actually text characters in them.
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
1
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
add a comment |
It sounds like the field's data type is Text. So it's sorting the numbers alphabetically.
Create a new field and populate it using the field calculator with
to_int("Your_Field")
The new field should sort numerically.
Bear in mind that this will only work for features which do not have any actually text characters in them.
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
It sounds like the field's data type is Text. So it's sorting the numbers alphabetically.
Create a new field and populate it using the field calculator with
to_int("Your_Field")
The new field should sort numerically.
Bear in mind that this will only work for features which do not have any actually text characters in them.
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
answered Feb 20 at 11:41
TeddyTedTedTeddyTedTed
69319
69319
1
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
add a comment |
1
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
1
1
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
You dont need to create a new field or even a virtual field, just right click on the a column header and choose "sort..." and you will access a calculator where you can enter the formula for sorting (in this case : to_int("Your_Field") ) strangely this formula work even if some feature have text character but the non numerical didn't seem to be sorted (the purely numerical get sorted at top or bottom depending in sort order)
– J.R
Feb 20 at 13:30
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f312899%2fqgis-3-4-4-sorts-numerical-values-as-text-solution%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
where did your data come from?
– Ian Turton♦
Feb 20 at 10:52
4
What is the field type of the field containing the values?
– Joseph
Feb 20 at 10:55