Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Show Conditional with multiple Variables

Hi all,

I have a few text boxes set up that I'm using to set variables, I'm then using these variables in the Show Conditional option for certain objects. This works fine when I want to show/ hide an object based on the value of one variable, but what about if I want to show/ hide an object based on the values of multiple variables?

E.g.

TextBox1 sets vShowABC to 1 and vShowDEF to 0

TextBox2 sets vShowABC to 0 and vShowDEF to 1

TextBox3 sets vShow123 to 1 and vShow456 to 0

TextBox4 sets vShow123 to 0 and vShow456 to 1

Object1 has the Show Conditional Expression set to vShowABC = 1

Object2 has the Show Conditional Expression set to vShowDEF = 1

So using the text boxes I'm able to control which object is displayed on my sheet by using the Show Condition Expressions:

(Object1) vShowABC = 1

(Object2) vShowDEF = 1

However, I want to create Object3 that has the Show Condition where vShowABC = 1 and vShow123 = 1. Please could someone show me the Expression syntax to make this possible?

Cheers!

1 Solution

Accepted Solutions
sudeepkm
Valued Contributor III

Re: Show Conditional with multiple Variables

you can set the layout condition of the Object 3 as vShowABC = 1 and vShow123 = 1. it should work.

can you please share your qvw too?

2 Replies
sudeepkm
Valued Contributor III

Re: Show Conditional with multiple Variables

you can set the layout condition of the Object 3 as vShowABC = 1 and vShow123 = 1. it should work.

can you please share your qvw too?

Not applicable

Re: Show Conditional with multiple Variables

As simple as that!

Many thanks.

Community Browser