Skip to main content
Question

Delete 0 values

  • August 16, 2022
  • 4 replies
  • 16 views
steven.bernd
Level 6
Forum|alt.badge.img+1

Hello, I use my formula

 

(CASE

WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%'

   THEN 'South Saxony'

WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%'

   THEN 'Saxony-Anhalt'

WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-W%'

   THEN 'West Saxony'

WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-B%'

   THEN 'Brandenburg'

ELSE ' ' END)

 

to cluster values.

 

Works great, except that it always gives me the ELSE values as 0 in my graph.

 

0 means that there is actually no ELSE, or in other words, everything is clustered.

 

How can I hide the 0 in the formula or in the component filter?

 

image 

thx :-)

4 replies

.
Level 8
  • .146004319
  • Level 8
  • August 16, 2022

You can make an component filter like:

 

FILTER "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%' OR

"/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%' OR [...]

 

This should only show you the inputs which don't have 0.

 

Or you can do it like this:

 

FILTER NOT ("/RWEE/PMCP_TAUFK"."ARBPL_AN" = 0)

 

steven.bernd
Level 6
Forum|alt.badge.img+1
  • steven.bernd
  • Author
  • Level 6
  • August 16, 2022

Merci. It works 💗

.
Level 8
  • .146004319
  • Level 8
  • August 17, 2022

Merci. It works 💗

glad to hear that!

Z
Level 8

Also, You can just delete (ELSE '').

It should be a structure like

CASE

WHEN A>B THEN 1

WHEN A>C THEN 2

END

 

If you dont use ELSE and directy write END, it doesnt give you any null values.

 

Filtering works well too.

 

I want to tell an alternative.

 

Cheers.

Community Code of ConductAccessibility statement