Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi,

I have one Object(Table Box).

my requirement is how to show and hide Object with button..i am using Personal Edition.please don't send qvw Applications. i need steps(How to we do the above requirement)

11 Replies
sibideepak
Creator II
Creator II

Hi ssr.qlikview ,

1. Create a variable vHideShow=1,

2. Create button Actions--> Add--> External-->Set Variable-->

Variable : vHideShow

Value : =If(vHideShow=1,0,1)

3. In the table box Layout-->Conditional : vHideShow=1

Thats all done !!!

sunilkumarqv
Specialist II
Specialist II

Create Variable:  vObject  make it as Show

step 1 : Create button

step 2: Actions Tab - External -Set variable

Set variable as vObject 

and Value as Show

Step 3 : on table box go to Layout tab:

Click conditional write a condition : =If($(vObject)='Show',1,0)

Apply try to click button

Not applicable
Author

Hi SS REDDY,

Try with below steps......

Step 1: click Ctrl+Alt+V to bring up variables list, add a new variable called vHide and assign 0 to the value. - Here we are simply initiating a variable to be used as a flag based on which we will set the visibility of a list box.

Step 2: Create a button, in Properties go to Actions tab and add an "External" Action Type  and select "Set Variable" and hit ok. In the Actions tab of properties, variable is vHide and Value should be =if(vHide=0,1,0). - Here we are toggling the flag using a single button. So if the vHide value is 0, then clicking the button will set it to 1 and if it is equal to 1 (when you click this button, the value changes to 1), then clicking the button again will set it to 0.

Step 3: In the list box properties, go to Layout tab and below Apply Theme button, select Conditional Show and type in vHide. - Typing in vHide as a condition basically is equal to saying if(vHide = 1, true, false). so in other words, we are saying that show the list box if vHide is equal to 1 else hide it.

Gysbert_Wassenaar

See this blog post: http://www.quickintelligence.co.uk/qlikview-buttons/


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Reddy,

First Declare Variable Like vTBShow. Then Place two Button object Show & Hide.

In show button properties -> Action - Add -- Select action type External -- Select setvariable

then give value to 1 for variable vTBShow

In Hide button properties -> Action - Add -- Select action type External -- Select setvariable

then give value to 0 for variable vTBShow

Next Table Box properties select Layout tab -- show -- Conditional -- vShowBx

Now when click hide button Table Box will hide and when u click show button it will show.


Please find attached images, u will get clear idea.

Regards,

Faisal

buzzy996
Master II
Master II

try this,

1.create a variable VariableShow

2.table box properties ---> Layout-Show-Conditional here set as VariableShow='1'

3.create two buttions one for show and another for hide

4.create a button/on show button--Properties-Actions- cleick Add- select from Action type: External  and Action: Set variable and click ok

5.on same action tab--place it here Variable as VariableShow and value 1

6.copy past the above button and set value as 0


now u play

Not applicable
Author

thanks Faisal, and can we do show/hide both with single button.

Gysbert_Wassenaar

Yes, you can for use a variable vShowHide and use a button with a Set Variable action to toggle its value: =NOT $(vShowHide). Give it an initial value of 0 or -1. Then use for one chart the conditinal expression =$(vShowHide) and for the other =Not $(vShowHide).


talk is cheap, supply exceeds demand
buzzy996
Master II
Master II

place both buttons one on above and set Button Properties-Layout-show-Condition as VariableShow='1' for show and VariableShow='0' for hide.