Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist III
Specialist 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?

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist 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?

View solution in original post

Highlighted
Not applicable

Re: Show Conditional with multiple Variables

As simple as that!

Many thanks.