showing/hiding two different dashboards on the same sheet

[#1]

Hi,

I need to reproduce in the same sheet two different dashboards from layout and conditions points of view and the user will choose which one want to visualize.

The first dashboard contains the materials which have the quantity  <> 0 and the second one the materials which have the quantity <> 0 or volume <> 0 or previous year quantity <> 0.
I created two flags in the script which respect this rule. They are named flag_actual and flag_history. Now I need to set each flag on each dashboard, but at the same time to have a macro button in order to select which one I want to see by pressing on it.
I don't know how to handle the two actions at the same time (hiding/showing the dashboards one at once and  each one to have his flag set). Should I do it with triggers/actions? which actions should I use and how?

thanks
Cristina

[rustyfishbones]

Hi Christina,

Create two variables, one called show.actual and one called show.history, set each value to 0

then for each object add the conditional show, see below example

Then create a button or text object and add an action > External Action > Set variable

like this

The chart will only show when the button is clicked, I hope this helps

[#3]

Thanks, but what about the flags?

When I show up the actual dashboard, it should be set the flag_actual, too; and when I show up the history dashboard, it should be set the flag_history.

[rustyfishbones]

Can you share your qvw?

or reduce the data and share

[vikasmahajan]

Please check with QVw Hope this will help you.

Vikas

[#6]

Please find the attached file of example.