topic Re: showing/hiding two different dashboards on the same sheet in QlikView

showing/hiding two different dashboards on the same sheet

Fri, 29 Nov 2013 10:36:40 GMT

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

Re: showing/hiding two different dashboards on the same sheet

rustyfishbones — Fri, 29 Nov 2013 10:43:02 GMT

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

Re: showing/hiding two different dashboards on the same sheet

Fri, 29 Nov 2013 10:58:47 GMT

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.

Re: showing/hiding two different dashboards on the same sheet

rustyfishbones — Fri, 29 Nov 2013 11:04:12 GMT

Can you share your qvw?

or reduce the data and share

Re: showing/hiding two different dashboards on the same sheet

vikasmahajan — Tue, 07 Jan 2014 06:28:20 GMT

Please check with QVw Hope this will help you.

Vikas

Re: showing/hiding two different dashboards on the same sheet

Tue, 07 Jan 2014 07:08:20 GMT

Please find the attached file of example.