Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have 4 table boxes in one sheet.
i want to show the table boxes by using buttons .
Hi,
use variable and show it conditionally in layout tab.
Regards
The way I normally do it is to create a variable, eg vTable1View
In the button: action for "set variable" with the variable name "vTable1View" and the value to =if(vTable1View=1,0,1)
Then in the table, in the layout tab, set the "show" option button to "conditional" and place "=vTable1View" the variable name in the condition text box.
Regards
I am attaching a sample file here for one table. You should be able to accomplish this for remaining tables that you want:
Hi Mani ,
Best way is Container object.it will have buttons for each chart object.
Create the Variable in front end "vShow"
Create Button , go to properties ->Action ->External->Set Variable,
Name - vShow, Value- =1
Like wise create 4 Buttons for 4 Table box. For 2 Button value will be =2, for 3 Button value =3 and so on.
Now for tablebox 1 conditional, put expression =if(vShow=1,1,0)
for tablebox 2 conditional, put expression =if(vShow=2,1,0)
for tablebox 3 conditional, put expression =if(vShow=3,1,0)
and so on
So that when you will click on Button 1, tablebox 1 will be shown and like wise others
There is one more way like below:
Instead of creating four Tables, Create one table and four buttons and then try to use "Variables With Parameters" concept. Hope this will fit into your requirement.
Here is the link to get a understanding about Variables with Parameters.