open another qvw with active sheet

yelin_nyu — Wed, 21 Jan 2015 18:38:37 GMT

I created some 'fake' sheets, I want the sheet to open another qvw when people active the tab. I set on open trigger, but it doesn't work. am I missing something? Open doc action works when I have a button. but I want people go straight to another doc by click on the tab itself

Re: open another qvw with active sheet

rwunderlich — Wed, 21 Jan 2015 19:30:22 GMT

It's a bit buried in the Help, but the Open Document action is not available as a Sheet Trigger. Search "Add Action Dialog" in the Help.

Launch and Open URL are not available as Sheet triggers as well, so you can't use them as a workaround. I can think of two alternatives:

1. Hide your tabs and make buttons or Text objects that look like Tabs.

a. Create a button that does the document open action.

b. Create a macro that presses the button.

SUB OpenOther

ActiveDocument.GetSheetObject("BU01").Press

END SUB

c. Have the Sheet Action run the macro.

**Caution -- I haven't tested this idea on the server.

-Rob

http://masterssummit.com

http://robwunderlich.com

topic Re: open another qvw with active sheet in QlikView

open another qvw with active sheet

Re: open another qvw with active sheet