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
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
New contributor
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
New contributor
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
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
New contributor
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
New contributor
New contributor
New contributor
asked 2 hours ago
Felix Althén BergmanFelix Althén Bergman
111
111
New contributor
New contributor
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
add a comment |
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
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.
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
});
}
});
Felix Althén Bergman 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
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.
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.
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.
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 1 hour ago
TeddyTedTedTeddyTedTed
64319
64319
add a comment |
add a comment |
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.
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.
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♦
2 hours ago
4
What is the field type of the field containing the values?
– Joseph
2 hours ago