QGIS 3.4.4 sorts numerical values as text, solution?How to sort field by ascending numerical order in QGIS...

boss asked me to sign a resignation paper without a date on it along with my new contract

How to create a custom script to force the download of a .csv file that is generated in real time?

Should you blow through the final approach course if the ATC forgot about you?

Uncountable set with a non-discrete metric

How can a kingdom keep the secret of a missing monarchy from the public?

Why does XLAT mean 'translate'?

How to play song that contains one guitar when we have two guitarists (or more)?

Why is it a problem for Freddie if the guys from Munich did what he wanted?

How to assess the susceptibility of a U.S. company to go bankrupt?

Father gets chickenpox, but doesn't infect his two children. How is this possible?

Is a 1hr 3min layover at ORD (Chicago) enough when coming in international?

How to explain one side of Super Earth is smoother than the other side?

Does an increasing sequence of reals converge if the difference of consecutive terms approaches zero?

Why are energy weapons seen as more acceptable in children's shows than guns that fire bullets?

Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?

How bad is a Computer Science course that doesn't teach Design Patterns?

How can I get results over the whole domain of my non-linear differential equations?

Is layered encryption more secure than long passwords?

Sing Baby Shark

How should I ship cards?

Getting size of dynamic c-style array VS use of delete[]. Contradiction?

Headless horseman claims new head

Pictures from Mars

General derivative of the exponential operator w.r.t. a parameter



QGIS 3.4.4 sorts numerical values as text, solution?


How to sort field by ascending numerical order in QGIS 2.14?Add images and other text in QGIS 3.0.2 (Windows)Field editor in QGIS 3.0 no Text edition buttonJoin attributes by location - false informationIs it possible to prompt messages and see progress when running R Script in QGIS 3.4.4?Is it possible to default an output directory for R Scripts in QGIS 3.4.4?Plugin Validity in Migration QGIS 2.18.19 to QGIS 3.4.4Difference between DEM raster in QGIS 2.18 and 3.4.4QGIS 3.4.4 Crash on vertex editorNo icons when installing QGIS 3.4.4













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







New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 1





    where did your data come from?

    – Ian Turton
    2 hours ago






  • 4





    What is the field type of the field containing the values?

    – Joseph
    2 hours ago
















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







New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 1





    where did your data come from?

    – Ian Turton
    2 hours ago






  • 4





    What is the field type of the field containing the values?

    – Joseph
    2 hours ago














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







New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












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







New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question







New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question






New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 hours ago









Felix Althén BergmanFelix Althén Bergman

111




111




New contributor




Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Felix Althén Bergman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 1





    where did your data come from?

    – Ian Turton
    2 hours ago






  • 4





    What is the field type of the field containing the values?

    – Joseph
    2 hours ago














  • 1





    where did your data come from?

    – Ian Turton
    2 hours ago






  • 4





    What is the field type of the field containing the values?

    – Joseph
    2 hours ago








1




1





where did your data come from?

– Ian Turton
2 hours ago





where did your data come from?

– Ian Turton
2 hours ago




4




4





What is the field type of the field containing the values?

– Joseph
2 hours ago





What is the field type of the field containing the values?

– Joseph
2 hours ago










1 Answer
1






active

oldest

votes


















4














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























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


    }
    });






    Felix Althén Bergman is a new contributor. Be nice, and check out our Code of Conduct.










    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









    4














    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




























      4














      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


























        4












        4








        4







        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 1 hour ago









        TeddyTedTedTeddyTedTed

        64319




        64319






















            Felix Althén Bergman is a new contributor. Be nice, and check out our Code of Conduct.










            draft saved

            draft discarded


















            Felix Althén Bergman is a new contributor. Be nice, and check out our Code of Conduct.













            Felix Althén Bergman is a new contributor. Be nice, and check out our Code of Conduct.












            Felix Althén Bergman is a new contributor. Be nice, and check out our Code of Conduct.
















            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

            ORA-01691 (unable to extend lob segment) even though my tablespace has AUTOEXTEND onORA-01692: unable to...

            Always On Availability groups resolving state after failover - Remote harden of transaction...

            Circunscripción electoral de Guipúzcoa Referencias Menú de navegaciónLas claves del sistema electoral en...