How to remove '0' values from the text graph in QGIS
Geographic Information Systems Asked by Ulla Rajala on May 21, 2021
I am trying to do some distribution maps using QGIS with text diagrams. The problem is that the graph shows also all the cases with No data or ‘0’. I do not want these in my graph. Any ideas where I can find the function that removes the 0 values from the graph?
One Answer
Try using CASE WHEN in the expression:
"if field is NULL or 0 then show an empty string '' else show field value":
CASE WHEN "field123" IS NULL THEN '' ELSE CASE WHEN "field123" = 0 THEN '' ELSE "field123" END END
Answered by BERA on May 21, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Peter Machado on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- haakon.io on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?