Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Activating sheets using Launch

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.

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

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

View solution in original post

15 Replies
robert_mika
Master III
Master III

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

Not applicable

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

trigger.png

robert_mika
Master III
Master III

Don't that activate the same sheet every time?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Will those macros work in ajax?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

robert_mika
Master III
Master III

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

Not applicable

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?

robert_mika
Master III
Master III

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?

bobbydave
Creator III
Creator III
Author

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