topic Re: Hi, in QlikView

Hi,

Mon, 06 Apr 2015 07:32:31 GMT

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)

Re: Hi,

sibideepak — Mon, 06 Apr 2015 11:11:32 GMT

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 !!!

Re: Hi,

sunilkumarqv — Mon, 06 Apr 2015 11:19:24 GMT

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

Re: Hi,

Mon, 06 Apr 2015 11:19:57 GMT

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.

Re: Hi,

Gysbert_Wassenaar — Mon, 06 Apr 2015 11:23:22 GMT

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

Re: Hi,

Mon, 06 Apr 2015 11:33:40 GMT

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

Re: Hi,

buzzy996 — Mon, 06 Apr 2015 11:40:42 GMT

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

Re: Hi,

Mon, 06 Apr 2015 11:41:52 GMT

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

Re: Hi,

Gysbert_Wassenaar — Mon, 06 Apr 2015 11:46:57 GMT

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).

Re: Hi,

buzzy996 — Mon, 06 Apr 2015 11:47:00 GMT

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

Re: Hi,

Anonymous — Mon, 06 Apr 2015 11:52:57 GMT

Hi SS Reddy.

yes you can do so

in your action where you are setting variable

vShow can have either of 2 values 0 or 1

so go to button action external, Set variables, Variable name, value = 1-vShow

in case it is 1 it will calculate 1-1=0

in case it is 0 it will calculate 1-0=1

Re: Hi,

Mon, 06 Apr 2015 12:09:06 GMT

Yes, You can

PFA