topic Re: Multiple conditions on conditionnal show/hide in QlikView

Multiple conditions on conditionnal show/hide

edemerdjieva — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Multiple conditions on conditionnal show/hide

sasiparupudi1 — Fri, 20 Apr 2018 08:19:58 GMT

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

Re: Multiple conditions on conditionnal show/hide

edemerdjieva — Fri, 20 Apr 2018 08:38:01 GMT

Thanks Sasidhar.

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

Re: Multiple conditions on conditionnal show/hide

techvarun — Fri, 20 Apr 2018 08:44:58 GMT

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

Re: Multiple conditions on conditionnal show/hide

sasiparupudi1 — Fri, 20 Apr 2018 08:47:58 GMT

Ex:

TextBox1

$(v_Index_01)

TextBox2

$(v_Index_02)

TextBox3

$(v_Index_03)

TextBox4

$(v_Index_06)

Re: Multiple conditions on conditionnal show/hide

olivierrobin — Fri, 20 Apr 2018 08:58:37 GMT

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