Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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 !!!
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
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.
See this blog post: http://www.quickintelligence.co.uk/qlikview-buttons/
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
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
thanks Faisal, and can we do show/hide both with single button.
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).
place both buttons one on above and set Button Properties-Layout-show-Condition as VariableShow='1' for show and VariableShow='0' for hide.