topic Re: Open an object on another sheet with a button in QlikView

Open an object on another sheet with a button

zenobendi — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Probably is a simple question but I am not able to find a solution. So I have two different sheet, on one sheet I have some charts and I have to create some buttons that automatically activate the other sheet and open specific objects.

It could be even better if there is the possibility to create a button that open an object (that is in another sheet ) in the sheet where I actually am, so without activating another sheet.

Thanks

Zeno

Re: Open an object on another sheet with a button

zenobendi — Thu, 14 Feb 2019 10:47:37 GMT

Or another possibility, probably the best, is to create a button to show the object that is hide in the chart. I've tried to create a variable (vShowTab) and put it in the object and in the graph and it works well (the object is hide and when i press the button it shows/open the object) but when I minimize the object it doesn't disappear

Re: Open an object on another sheet with a button

FKoenig — Thu, 14 Feb 2019 15:03:29 GMT

Rather than minimize the object, utilize a button to revert your variable back. You can even use the same button, if you like, and modify the button text to indicate the state of the object.

Change your button action to read something like:
=IF($(vShowTab)=1,0,1)

And your text on the button could then read:

=IF($(vShowTab)=1,'Hide Object','Show Object')