HIDE OBJECT

[adiarnon]

HI,

i want to hide object base on condition

the condition should be-

i should see the object im the current selection is empty

or

if the the curren selection have field - "employee","department","division"

if one or more of those fields and only those fields are selected i should see the object.

if a selection made on any othe field i want to hide the object.

how can i do it?

adi

[Peter_Cammaert]

Create a big conditional show expression for this object that checks whether anything is selected in any of the remaining fields at all. You can use GetSelectedCount() to do that.

[jonathandienst]

Its easy to do the first part of your requirement- the show condition would be

=GetSelectedCount(employee)

  or GetSelectedCount(department)

  or GetSelectedCount(division)

To hide the object when any other selection made is more complicated. You could try

=(GetSelectedCount(employee)

  or GetSelectedCount(department)

  or GetSelectedCount(division))

  and GetSelectedCount(otherfield1) = 0

  and GetSelectedCount(otherfield2) = 0

  and GetSelectedCount(otherfield3) = 0

  ...and so on

You will have to list all the other selectable fields in this expression.

[adiarnon]

but i have alot of other fields

[robert_mika]

in Conditional Show use:

FindOneOf('department', GetCurrentSelections(Con))=1

   or  

   FindOneOf('employee',GetCurrentSelections(Con))=1

    or    FindOneOf('division',GetCurrentSelections(Con))=1

[sasikanth]

HI,

Try This

Chart Properties-->Layout-->Show->Condition

len(GetCurrentSelections())=0 OR GetSelectedCount(employee)>0 OR GetSelectedCount(department)>0 OR GetSelectedCount(division)>0

[jonathandienst]

Here's a different take that removes the need to list all the fields in the expression:

=(GetSelectedCount(employee)

  or GetSelectedCount(department)

  or GetSelectedCount(division))

And Alt(SubStringCount(GetCurrentSelections('|', '','', 0), '|') + 1, 0) <= RangeSum(

  If(GetSelectedCount(employee), 1),

  If(GetSelectedCount(department), 1),

  If(GetSelectedCount(division), 1)

)

This counts the total number of field selections (the Alt(SubStringCount(GetCurrentSelections('|', '','', 0), '|') + 1, 0) part and counts the number of the employee/department\division fields selected. If another field has selections, then this condition should fail.

[adiarnon]

but if a selection made on any othe field i want to hide the object.

[adiarnon]

but if a selection made on any other field i want to hide the object.

like if i have a selection on-

employee and year

i dont want to see the object

[susovan]

Hi,

You can also try this attached file.

I have use this expression(=SubStringCount(Concat(Dimension, '|'), 'Division')) in the attached application. !