Attribute filter in a Subset excluding an element

SaraLM · Nov 16th 2018, 2:11pm

Hi Jedox Community,

I´d like to set an attribute filter in a dynarange subset.
It should exclude all elements that have "DP" as an attribute.

I tried several expressions but none worked... Screenshot is attached.
What is the correct expression or operator?

Thanks in advance for your help.

Sara

dominik_l · Nov 19th 2018, 5:37pm

If you enable the "Regular expression" option on AFilter, you can try with an expression like this:

^(?!.*DP.*)
That would filter anything where DP occurs.

This one should filter out exact matches (i.e. where attribute is exactly DP), though I'm not really a RegEx expert:
^(?!DP$).*$

Attribute filter in a Subset excluding an element

Attribute filter in a Subset excluding an element

Share

Tags