QGIS 3.4.4 sorts numerical values as text, solution?












2















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?










share|improve this question


















  • 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
















2















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?










share|improve this question


















  • 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














2












2








2








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?










share|improve this question














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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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














  • 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










1 Answer
1






active

oldest

votes


















6














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.






share|improve this answer



















  • 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











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
});


}
});














draft saved

draft discarded


















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









6














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.






share|improve this answer



















  • 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
















6














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.






share|improve this answer



















  • 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














6












6








6







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.






share|improve this answer













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.







share|improve this answer












share|improve this answer



share|improve this answer










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














  • 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


















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Biblatex bibliography style without URLs when DOI exists (in Overleaf with Zotero bibliography)

ComboBox Display Member on multiple fields

Is it possible to collect Nectar points via Trainline?