I would like to graduate from a column of mine with decimal numbers. For this I want to apply the Jenks discretisation and exclude zero. I tried this, but it didn’t work…

enter image description here

Do you have any idea to do that?

  • try enclosing the column name in "" – geozelot Sep 21 '18 at 9:46
  • I tried : "I_EVEPOP" > 0 and "I_EVEPOP" > '0' but doesn't work... – VioGeo Sep 21 '18 at 9:58

Your query of:


Is a binary question. You are asking QGIS, is it bigger than 0. If so it will show a 1, if not it will show a 0.

What you want is a conditional:

|improve this answer|||||

"I_EVEPOP" > '0' should work.

Columns, when referenced in equations, need to be put in double quotation marks, any value you want to place, grab or check for in single marks.

|improve this answer|||||
  • I tried but still don't work... – VioGeo Sep 21 '18 at 9:56

You need to switch to Rule-based styling to remove 0 value from the classification. You can use Graduated classification first to classify your data using the desired column as it is and using Mode: Natural Breaks (Jenks) as you can see below:

enter image description here

However, to remove the 0 value you need to switch to Rule-Based classification, and as you can see in the following image, the highlighted rule shows the ColumnName >= Value. In this example New_ID >= 0.000

enter image description here

You need to change it to New_ID > 0.000 by removing the equal = sign. But in this case the polygon with the value equal zero will disappear.

enter image description here

|improve this answer|||||
  • 1
    Actually, I would like the discretisation to be calculated without the 0. If I do that the discretisation integrated the 0 values. – VioGeo Sep 21 '18 at 11:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.