topic Re: Urgent: Activate Specific Tab - Macro Trigger in QlikView

Urgent: Activate Specific Tab - Macro Trigger

Thu, 27 Oct 2011 04:53:52 GMT

Hi everyone,

I would like to assign a macro to a tab. On clicking this tab the macro would open a new qlikview document specified in the path mentioned. Find below
the macro that i am assigning to the tab.

Sub OpenHome

set App=ActiveDocument.GetApplication

App.OpenDoc "Path\Filename.qvw","",""

End Sub

The new document has several tabs. My requirement is to activate a specific tab in that new document. Not sure how this can be done?

Any ideas?

Tkx.
Harsha

Urgent: Activate Specific Tab - Macro Trigger

Thu, 27 Oct 2011 05:22:02 GMT

In the second document: Go to Document Properties->Triggers->On Open and add action Layout->Activate Sheet.

If you want to do this dynamically, you can a set variable value in App.OpenDoc and use that to activate sheet.

Hope this helps,

Kiran

Urgent: Activate Specific Tab - Macro Trigger

Thu, 27 Oct 2011 19:11:40 GMT

Hi Kiran,

I would like to have it dynamic, Can you please share an example how i can do this in the macro?

Tkx.

Harsha

Re: Urgent: Activate Specific Tab - Macro Trigger

Fri, 28 Oct 2011 03:42:34 GMT

Check of the attachement. Once unzipped you would find two files, HomeDoc and TargetDoc. Demonstrated opening TargetDoc from HomeDoc and dynamically activating the sheet.

OpenDoc:

Has a variable which tells which sheet in TargetDoc to open.

Two button set the variable and runs a macro.

Macro reads the variable, opens TargetDoc and activates the sheet specified in the variable.

Hope this demonstrates your requirement.

Regards,

Kiran.

Re: Urgent: Activate Specific Tab - Macro Trigger

Fri, 28 Oct 2011 16:10:59 GMT

Works Perfectly....Thanks a lot Kiran

- Harsha

Urgent: Activate Specific Tab - Macro Trigger

rotmangadi — Mon, 30 Jan 2012 15:47:24 GMT

It was very helpful for me as well,

Thanks!

Re: Urgent: Activate Specific Tab - Macro Trigger

Anonymous — Wed, 27 Feb 2013 21:34:36 GMT

Hi Kiran, I have a question.

Why if you put in mode webview, the macro dont work, please help me.

Regards.

Re: Urgent: Activate Specific Tab - Macro Trigger

jerrysvensson — Thu, 28 Feb 2013 10:43:34 GMT

The ActiveSheet Trigger doesn't work in WebView.

Try using a button instead.

Re: Urgent: Activate Specific Tab - Macro Trigger

Anonymous — Thu, 28 Feb 2013 15:10:43 GMT

Dear Kiran,

My question is, I want to open Word documents in a OpenFiles.qvw,

and I created a button that when selecting the button open the word document.

What I did was

Actions tab launch add action and I gave the path where the archivo.qvw was stored

😧 \ QlikView \ Production \ Documents \ Transaction \ User.docx

attached print 1.

Everything works fine, but when I publish the Access Point does not worke and I can't open word documents.

Regards,