I have a sheet which contains 3 buttons, 1 chart and 1 pivot chart when it’s initially loaded.
The 3 buttons are labeled as “Expense by Trend”, “Expense by Stacked” and “Expense by Other”.
When the “by Trend” is clicked, a Line Chart is used and a Piviot Chart is used. When the “by Stacked” is clicked, a Bar Chart
and Pivot Chart are used. All these are on the same sheet. Obviously some objects are being hidden when not in use as each
object has its own Object ID.
I’m interested in finding out all the code that is behind the button click event and how the charts are “activated’ depending on
which button is pressed. Also how do I “unhide” all the objects on this sheet so I can see them in Qlikview Desktop screen.
Thank you.
