Multiple conditions on conditionnal show/hide

[edemerdjieva]

Hello all,

I have an object that is repeated on several sheets (same object id) of the QV dashboard. It needs to be hidden on some sheets but not others.

So I use the conditional show/hide as follows:

$(v_Index_01)<>5 or $(v_Index_02)<>4 or $(v_Index_03)<>5 or $(v_Index_06)<>1

where v_Index_0* is the sheet number.

Unfortunately, it doesn't work.  If I leave only one condition (ex: $(v_Index_01)<>5)  then it works and the object is hidden on the selected sheet.

Can someone explain why this happens? What can be done in this case ? The option I'm trying to avoid is multiplying the objects.

Thanks for the help!

[sasiparupudi1]

May be the values in the variables are not being rest.. put the variables in  individual text boxes and see how they change..based on the behaviour you may change your show/hide condition

hth

[edemerdjieva]

Thanks Sasidhar.

But I don't see what you mean by "individual text boxes". Can you show an example, please?

[techvarun]

Create an input box and all the variables used in the condition and check the values are coming as expected or not

[sasiparupudi1]

Ex:

TextBox1

$(v_Index_01)

TextBox2

$(v_Index_02)

TextBox3

$(v_Index_03)

TextBox4

$(v_Index_06)

[olivierrobin]

as i understand, your formula is copied on each sheet

but as the values of variables are at the document level, the formula is evaluated with the values event if you leave the sheet where they are set

so you may have to clear the variables on leaving each sheet via triggers