topic How to hide and show the tables based on two buttons. in QlikView

How to hide and show the tables based on two buttons.

Wed, 13 Jul 2011 04:54:18 GMT

Hi All,

Could you anyone tell me the way to hide the charts based on two buttons...

Thanks in advance...

How to hide and show the tables based on two buttons.

kaushiknsolanki — Wed, 13 Jul 2011 06:18:43 GMT

Hi,

Create a variable called vVisibility.

Assign value 1. (Say 1 for show and 0 for hide)

Go to properties of the chart. -> Caption -> Click on conditional

Type

vVisibility = 1

Create a Button.

Add action as External -> Set variable -> type Variable name i.e vVisibility

in value tyep

if(vVisibility =1,0,1)

click ok.

Regards,

Kaushik Solanki

How to hide and show the tables based on two buttons.

Wed, 13 Jul 2011 07:02:11 GMT

Sorry I use QV 8.5 version so i dnt have this

Add action as External -> Set variable -> type Variable name i.e vVisibility.

What can be done for this......

How to hide and show the tables based on two buttons.

Wed, 13 Jul 2011 12:20:43 GMT

Can any one help me on this issues...

Re: How to hide and show the tables based on two buttons.

Wed, 13 Jul 2011 12:26:46 GMT

Can any one help me on this issues...

Re: How to hide and show the tables based on two buttons.

Wed, 13 Jul 2011 12:46:49 GMT

In this case you have to write Macro (Ctrl + M)

Something like this:

Sub ToggleVariable

Set var_vVisibility= ActiveDocument.Variables("vVisibility")
If var_vVisibility.GetContent.String = "1" Then
ActiveDocument.Variables("vVisibility").SetContent "0", false
Else
ActiveDocument.Variables("vVisibility").SetContent "1", false
End If
End Sub

Then your chart should be shown... Let us know if it doesn't work.

Regards,Miha