Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dahsboard which is having 5 tabs (A,B,C,D,E)
A is the tab which will explain the details of B,C,D,E tabs.
Now when I click on the first tab i.e A the rest of the tabs should open its like + symbol.
So, in dashboard it should show only A tab. Once I click only rest of the tabs should appear.
can anyone come across the same scenario. FYI..I am using 8.2 version
Thanks,
You could have a variable that is set when entering the sheet and a conditional show on that vaiable on the other sheets that you want to be shown.
How to create variable and use in conditional.
Thanks,
To create a variable:
Settings -> Variable OverView -> Add
Hi,
You Can try this .I think this will solve your problem.If I am able to understand your problem.
Regards,
Ravi
No Ravi, this is not what I am expecting.
Can anyone have idea on this??
Thanks,
Hi Experts,
Any solution for this query??
Thanks,
The only sheet event triggers are OnActivateSheet and OnLeaveSheet. Since tab A is already shown when you open the dashboard, NO TRIGGER IS FIRED when you click on that tab. Therefore, you can't respond to someone clicking on the tab by opening other tabs. You could do it if it was NOT already displayed, since then clicking on it would fire OnActivateSheet. But with it already displayed, no.
It's not QUITE what you want, but you could create a transparent button the size of the entire sheet. That way, if they click anywhere on the sheet EXCEPT for the tab, you can capture that and respond to it. The response in this case would be to set a variable, and then have the other sheets conditionally shown based on the value of that variable, just like Daniel said earlier.
I can create an example for that if you want, but it isn't what you asked for, so I don't want to waste the time otherwise.
You could also eliminate tabs and replace them with your own controls, but in my opinion that would be needlessly complicated.