Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro issue - jump from one application to another application and pass the values

I would like to have a macro to pass the user selection from one application to
another qlikview application.

Macro for jump from one application to other application based on the user selected values to open 2nd application particular sheet

Example :
Application 1 :

User will select Customerno and press the button

Application 2 has to open with Sheet1
Sheet1 has Textobject - we have to pass the value which is selected
from User in application 1 to application 2 .

sub Press
set CustomernoVar = ActiveDocument.Variables("customerno")
CustomerNo = CustomernoVar.GetContent.String
set val=ActiveDocument.Fields("CustomerNo").GetSelectedValues
if (val.count)=0 then
msgbox("Select a Customer Number")
else
showvalue = val.Item(0).Text
set app = ActiveDocument.GetApplication
app.Launch "C:\Program Files\Internet Explorer\IEXPLORE.EXE","qvp://CustomerDetails.qvw&client=Plugin="&(showvalue)
ActiveDocument.Fields("CustomerNo").Select (CustomerNo)
set s = ActiveDocument.ActiveSheet.SheetObjects("SH90").GetSheet
end if
end sub


Advance thanks for your support and help.

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

I don't think you can do what you are trying to accomplish, using app.launch ...

First of all, if you are on version 9.00 or higher, - why not use the Action and Open the second document with the selections passed through? Much cleaner...

If you can't use an Action, try opening the second document using macro function doc.Open and then propagating user selections etc...