Hide Data of Dimension under List box

[#1]

Dear All,

Is there any way to Hide Data of Dimension under List box.

Ex: Process is the Dimension, ABC, XYZ and LMN are the data inside dimension Process.

      When i select Process as Dimension in List Box i want to hide any of the Data like ABC or XYZ etc.

Please suggest and help on the same.

Thank You...

[bruno_m_santos]

You can build an expression in List Box:

If (Dim<>'aaa' or Dim<>'vvv', Dim)

Thanks

Bruno

[jvishnuram]

Hi Bruno,

You can also use only() Function

syntax is Aggr(Only(${<Dim-={"aaa","ww"}>}Dim),Dim)

[#4]

attched is what you are looking for?

In "Hide Dim" go to General > Tick Hide Excluded

[#5]

Hi,

basically, you create a Calculated Expression instead of putting your dimension (last choice of the combo)

And the expression you will edit is sth like:  

= if (match( Product, 'A','B'), Product, Null())

Fabrice

[richard · Accepted solution]

To hide the excluded values, use your listbox with and expression and then insert this expression code:

=if(not match(Proces, 'ABC', 'XYZ'), Process)

You only need to insert the values to be excluded separated by ==> ,

You can even replace the values to be excluded with a variable.

[#7]

Thank You Richard and really helped me while selecting LED check Box.

[#8]

Thank You FABRICE44. It helped me in Hiding correct while using LED check box.

[#9]

Thanks to all for your help and it worked