topic Re: Activating sheets using Launch in QlikView

Activating sheets using Launch

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

So ... I have two buttons on my document which will open the another qlikview application but I want the two buttons to activate one sheet from the application, the second button to open the second sheet from the application.

e,g,

So I have a Department application that has Button A and Button B and a Department application.

When I click on Button A, this should open Premiums sheet of the department application and Button B should launch the Claims sheet of the department application.

Is there any way to do so. I can launch the external applicaiton with the trigger but its Activating the Sheet I want opened is the problem.

Any help appreciated.

Re: Activating sheets using Launch

robert_mika — Tue, 12 May 2015 15:19:26 GMT

You can use macros

Sub ButA

set App = ActiveDocument.GetApplication

set newdoc = App.OpenDoc ("c:\Users\......\Desktop\Department.qvw","","")

newdoc.Sheets("Claims").Activate

End Sub

Sub ButB

set App = ActiveDocument.GetApplication

set newdoc = App.OpenDoc ("c:\Users\........\Desktop\Department.qvw","","")

newdoc.Sheets("Premium").Activate

End Sub

Re: Activating sheets using Launch

Tue, 12 May 2015 17:38:03 GMT

have you tried to do it by setting a trigger on open in document properties that wil activate your desired sheet?

Re: Activating sheets using Launch

robert_mika — Tue, 12 May 2015 20:03:56 GMT

Don't that activate the same sheet every time?

Re: Activating sheets using Launch

rwunderlich — Tue, 12 May 2015 20:26:47 GMT

Will those macros work in ajax?

Re: Activating sheets using Launch

rwunderlich — Tue, 12 May 2015 20:29:06 GMT

If using ajax client, you can pass the sheet as a parameter of the URL.

See

Passing Parameters in a URL and Document Chaining

AJAX and URL parameters

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Activating sheets using Launch

robert_mika — Tue, 12 May 2015 20:40:35 GMT

I assume not. but unless I got this question right bobbydave is asking for desktop app.

Re: Activating sheets using Launch

Wed, 13 May 2015 06:11:44 GMT

Yes he should be able to specify which sheet. Although never tried might even be possible to make the sheet selection dynamic using a pick match or some other conditional function. what do you think?

Re: Activating sheets using Launch

robert_mika — Wed, 13 May 2015 07:43:00 GMT

Thank you for the links Rob.

The second one clearly explain how to use parameters to open specific sheet but is there a way by just using triggers to pass the parameter to second qvw file to open it on desired sheet on desktop?

Re: Activating sheets using Launch

bobbydave — Wed, 13 May 2015 09:44:14 GMT

I've tried this to activate SH02 and SH04

There are two different buttons; one should open SH02 and the other button should open/activate SH04

I can launch the application (another qvw) but they both open on SH04

Re: Activating sheets using Launch

bobbydave — Wed, 13 May 2015 09:49:26 GMT

This is exactly what I needed.

I am not too familiar with macros but this does exactly what I needed.

Thanks Robert

Re: Activating sheets using Launch

bobbydave — Wed, 13 May 2015 09:49:55 GMT

Thanks but this would only open the same sheet.

Re: Activating sheets using Launch

robert_mika — Wed, 13 May 2015 09:58:50 GMT

Go to Tolls-->Edit Module and add the above code.

Then assign one for each button.

I'm sure it will work

Re: Activating sheets using Launch

bobbydave — Wed, 13 May 2015 10:02:30 GMT

It does. I used it. And worked Magically.

Thanks again

Re: Activating sheets using Launch

bobbydave — Wed, 13 May 2015 10:14:15 GMT

My next thing though is because it opens the same application, the two sheets are visible and I only want the Claims sheet to be visible (the Premiums tab will be hidden) when opening the Claims button and the Premiums button shows the Premiums tab (hiding the Claims tab).

Do you think section access applied to a button would work?

I've tried conditional formatting to hide these but wont work

In your macro, you have activate sheet; is there a deactivate sheet alternative?

Re: Activating sheets using Launch

rwunderlich — Wed, 13 May 2015 17:21:24 GMT

If the trigger Action was Launch, you could use the sheet parameter?

-Rob