Skip to main content
Question

Delete 0 values

  • Aug 16, 2022 6:13 AM UTC
  • 4 replies
  • 138 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

  • Aug 16, 2022 7:38 AM UTC

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
  • Author
  • Level 6
  • Aug 16, 2022 10:04 AM UTC

Merci. It works 💗


  • Aug 17, 2022 12:04 PM UTC

Merci. It works 💗

glad to hear that!


  • Jan 31, 2023 8:13 PM UTC

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.