Skip to main content

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 :-)

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)

 


Merci. It works 💗


Merci. It works 💗

glad to hear that!


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.


Reply