QGIS Summing data from a column in attribute table

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
1
down vote

favorite












I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table. In my attribute table, I'd like to add all the numbers in the red box.
I'd like to add all the numbers together from the column UN_2015_E. Is there a way to do so?






qgis







share|improve this question



























    up vote
    1
    down vote

    favorite












    I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table. In my attribute table, I'd like to add all the numbers in the red box.
    I'd like to add all the numbers together from the column UN_2015_E. Is there a way to do so?






    qgis







    share|improve this question

























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table. In my attribute table, I'd like to add all the numbers in the red box.
      I'd like to add all the numbers together from the column UN_2015_E. Is there a way to do so?






      qgis







      share|improve this question















      I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table. In my attribute table, I'd like to add all the numbers in the red box.
      I'd like to add all the numbers together from the column UN_2015_E. Is there a way to do so?






      qgis




      qgis






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago









      Vince

      14.2k32546




      14.2k32546










      asked 1 hour ago









      Guillaume

      323




      323




















          3 Answers
          3






          active

          oldest

          votes

















          up vote
          1
          down vote



          accepted










          An other possibility with the merge tool :



          enter image description here



          enter image description here






          share|improve this answer




















          • @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
            – Taras
            12 mins ago

















          up vote
          4
          down vote













          Add the statistics panel (view - panels - statistics panel) to your window layout and then let it show you the statistics of your column.






          share|improve this answer



























            up vote
            2
            down vote













            There are several methods that I may refer you to.



            1. First one is called "Show statistical summary". Symbolized as a Sigma symbol(Sigma) on the main QGIS working window.

            Show_statistical_summary



            In the appearing window, you just need to choose the layer which you are interested in (population data) and choose the field that you want to explore, seems like "UN_2015_E". The total number will be calculated just in the row called 'Sum'.



            The same result can be achieved with View > Statistical summary



            Or as it was already mentioned by @Erik you can proceed with View > Panels > Statistics Panel



            1. There is a plugin called Group Stats, see the image below.

            Group_Stats



            However, I apply this plugin when I require some complicated calculations and do not want to launch Excel, because this plugin provides some output options etc.



            1. If you open you Attribute table and put the layer in edited mode, then you will be able to type sum("UN_2015_E") in the Expression dialogue and get the result as an Output preview.





            share|improve this answer


















            • 1




              To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
              – J.R
              7 mins ago










            • @J.R, possible! Thank you for a hint
              – Taras
              5 mins ago










            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',
            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%2f301845%2fqgis-summing-data-from-a-column-in-attribute-table%23new-answer', 'question_page');

            );

            Post as a guest

















            3 Answers
            3






            active

            oldest

            votes








            3 Answers
            3






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            1
            down vote



            accepted










            An other possibility with the merge tool :



            enter image description here



            enter image description here






            share|improve this answer




















            • @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
              – Taras
              12 mins ago














            up vote
            1
            down vote



            accepted










            An other possibility with the merge tool :



            enter image description here



            enter image description here






            share|improve this answer




















            • @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
              – Taras
              12 mins ago












            up vote
            1
            down vote



            accepted







            up vote
            1
            down vote



            accepted






            An other possibility with the merge tool :



            enter image description here



            enter image description here






            share|improve this answer












            An other possibility with the merge tool :



            enter image description here



            enter image description here







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 21 mins ago









            Christophe

            697311




            697311











            • @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
              – Taras
              12 mins ago
















            • @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
              – Taras
              12 mins ago















            @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
            – Taras
            12 mins ago




            @Guillaume, be careful with a Merge Selected Features tool since it does not work with points in case you have population data for georeferenced addresses.
            – Taras
            12 mins ago












            up vote
            4
            down vote













            Add the statistics panel (view - panels - statistics panel) to your window layout and then let it show you the statistics of your column.






            share|improve this answer
























              up vote
              4
              down vote













              Add the statistics panel (view - panels - statistics panel) to your window layout and then let it show you the statistics of your column.






              share|improve this answer






















                up vote
                4
                down vote










                up vote
                4
                down vote









                Add the statistics panel (view - panels - statistics panel) to your window layout and then let it show you the statistics of your column.






                share|improve this answer












                Add the statistics panel (view - panels - statistics panel) to your window layout and then let it show you the statistics of your column.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 1 hour ago









                Erik

                2,30417




                2,30417




















                    up vote
                    2
                    down vote













                    There are several methods that I may refer you to.



                    1. First one is called "Show statistical summary". Symbolized as a Sigma symbol(Sigma) on the main QGIS working window.

                    Show_statistical_summary



                    In the appearing window, you just need to choose the layer which you are interested in (population data) and choose the field that you want to explore, seems like "UN_2015_E". The total number will be calculated just in the row called 'Sum'.



                    The same result can be achieved with View > Statistical summary



                    Or as it was already mentioned by @Erik you can proceed with View > Panels > Statistics Panel



                    1. There is a plugin called Group Stats, see the image below.

                    Group_Stats



                    However, I apply this plugin when I require some complicated calculations and do not want to launch Excel, because this plugin provides some output options etc.



                    1. If you open you Attribute table and put the layer in edited mode, then you will be able to type sum("UN_2015_E") in the Expression dialogue and get the result as an Output preview.





                    share|improve this answer


















                    • 1




                      To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
                      – J.R
                      7 mins ago










                    • @J.R, possible! Thank you for a hint
                      – Taras
                      5 mins ago














                    up vote
                    2
                    down vote













                    There are several methods that I may refer you to.



                    1. First one is called "Show statistical summary". Symbolized as a Sigma symbol(Sigma) on the main QGIS working window.

                    Show_statistical_summary



                    In the appearing window, you just need to choose the layer which you are interested in (population data) and choose the field that you want to explore, seems like "UN_2015_E". The total number will be calculated just in the row called 'Sum'.



                    The same result can be achieved with View > Statistical summary



                    Or as it was already mentioned by @Erik you can proceed with View > Panels > Statistics Panel



                    1. There is a plugin called Group Stats, see the image below.

                    Group_Stats



                    However, I apply this plugin when I require some complicated calculations and do not want to launch Excel, because this plugin provides some output options etc.



                    1. If you open you Attribute table and put the layer in edited mode, then you will be able to type sum("UN_2015_E") in the Expression dialogue and get the result as an Output preview.





                    share|improve this answer


















                    • 1




                      To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
                      – J.R
                      7 mins ago










                    • @J.R, possible! Thank you for a hint
                      – Taras
                      5 mins ago












                    up vote
                    2
                    down vote










                    up vote
                    2
                    down vote









                    There are several methods that I may refer you to.



                    1. First one is called "Show statistical summary". Symbolized as a Sigma symbol(Sigma) on the main QGIS working window.

                    Show_statistical_summary



                    In the appearing window, you just need to choose the layer which you are interested in (population data) and choose the field that you want to explore, seems like "UN_2015_E". The total number will be calculated just in the row called 'Sum'.



                    The same result can be achieved with View > Statistical summary



                    Or as it was already mentioned by @Erik you can proceed with View > Panels > Statistics Panel



                    1. There is a plugin called Group Stats, see the image below.

                    Group_Stats



                    However, I apply this plugin when I require some complicated calculations and do not want to launch Excel, because this plugin provides some output options etc.



                    1. If you open you Attribute table and put the layer in edited mode, then you will be able to type sum("UN_2015_E") in the Expression dialogue and get the result as an Output preview.





                    share|improve this answer














                    There are several methods that I may refer you to.



                    1. First one is called "Show statistical summary". Symbolized as a Sigma symbol(Sigma) on the main QGIS working window.

                    Show_statistical_summary



                    In the appearing window, you just need to choose the layer which you are interested in (population data) and choose the field that you want to explore, seems like "UN_2015_E". The total number will be calculated just in the row called 'Sum'.



                    The same result can be achieved with View > Statistical summary



                    Or as it was already mentioned by @Erik you can proceed with View > Panels > Statistics Panel



                    1. There is a plugin called Group Stats, see the image below.

                    Group_Stats



                    However, I apply this plugin when I require some complicated calculations and do not want to launch Excel, because this plugin provides some output options etc.



                    1. If you open you Attribute table and put the layer in edited mode, then you will be able to type sum("UN_2015_E") in the Expression dialogue and get the result as an Output preview.






                    share|improve this answer














                    share|improve this answer



                    share|improve this answer








                    edited 11 mins ago

























                    answered 31 mins ago









                    Taras

                    1,3461521




                    1,3461521







                    • 1




                      To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
                      – J.R
                      7 mins ago










                    • @J.R, possible! Thank you for a hint
                      – Taras
                      5 mins ago












                    • 1




                      To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
                      – J.R
                      7 mins ago










                    • @J.R, possible! Thank you for a hint
                      – Taras
                      5 mins ago







                    1




                    1




                    To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
                    – J.R
                    7 mins ago




                    To give a complete answer you could add a 4. creating a virtuel layer with the right SQL query give you a table with the sum that you could use in a composer
                    – J.R
                    7 mins ago












                    @J.R, possible! Thank you for a hint
                    – Taras
                    5 mins ago




                    @J.R, possible! Thank you for a hint
                    – Taras
                    5 mins ago

















                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f301845%2fqgis-summing-data-from-a-column-in-attribute-table%23new-answer', 'question_page');

                    );

                    Post as a guest
































































                    Comments

                    Post a Comment

                    Popular posts from this blog

                    How to decode/decipher Mozilla Firefox proprietary .jsonlz4 format? (sessionstore-backups/recovery.jsonlz4)

                    Image
                    Clash Royale CLAN TAG #URR8PPP up vote 3 down vote favorite I'm trying to get a handle on Mozilla Firefox's proprietary file format .jsonlz4 , used, for example, for sessionstore-backups/recovery.jsonlz4 , but to no avail. How do I get back my data, specifically, some long text I've typed in some textareas of a crashed session? It's my data! firefox backup json session-restore jsonlz4 share | improve this question asked 3 hours ago cnst 1,049 3 16 33 add a comment  |  up vote 3 down vote favorite I'm trying to get a handle on Mozilla Firefox's proprietary file format .jsonlz4 , used, for example, for sessionstore-backups/recovery.jsonlz4 , but to no avail. How do I get back my data, specifically, some long text I've typed in some textareas of a crashed session? It's my data! firefox backup json session-restore jsonlz4 share | improve this question asked 3 hours ago cnst ...
                    Read more

                    White Anglo-Saxon Protestant

                    Image
                    White Anglo-Saxon Protestants ( WASPs ) are a social group of wealthy and well-connected white Americans, of Protestant and predominantly British ancestry, who trace their ancestry to the American colonial period. Until at least the 1960s, this group has dominated American society and culture and dominated in the leadership of the Whig and Republican parties. They usually are very well placed in major financial, business, legal and academic institutions and had close to a monopoly of elite society due to intermarriage and nepotism. [1] During the latter half of the twentieth century, outsider ethnic and racial groups grew in influence and WASP dominance weakened. Americans are increasingly criticizing the WASP hegemony and disparaging WASPs as the epitome of "the Establishment". The Random House Unabridged Dictionary (1998) says the term is "Sometimes Disparaging and Offensive". [2] [3] The term WASP is often used as a pejorative to classify their historical dom...
                    Read more

                    How to be valuable when automation & IT are stealing my job (and maybe my whole career)? [closed]

                    Image
                    Clash Royale CLAN TAG #URR8PPP .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0; up vote 10 down vote favorite I am a non-IT employee, graduated in business studies, and work in a field related to customer relationship management. I have grown in this field during the past five years since completing my education, and there is a frightening trend in my company and across the industry: People are being laid off because automation can do the jobs of hundreds with the help of programming. Even my own team was halved and I keep wondering what I can do to stay relevant in the longer run. I have the sincere impression that very soon my team won't exist anymore and also skills/jobs in my field will become redundant across other industries. It also seems that only high level functions will require employees but they will be people with solid IT qualifications. So here is my question: How to ensure I stay valuable to my company (or eve...
                    Read more