Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

opening another document

Dear I got a QVW document in which I put a button to allow users to open other document

Actually I want also to activate a specific sheet in the new document

I managed to write a macro that does this and everything is working just fine

however when I deploy the doculment to QlikView server and the users access the document via the web browser (IE-9) that macro doesn't work at all

Please advise

Are there settings that should be applied at the level of the web browser ?

Note the macro is as follows:

sub openDoc

set App = ActiveDocument.GetApplication

set vDoc = ActiveDocument.GetVariable("vDocument")

set vSht = ActiveDocument.GetVariable("vSheet")

set newdoc = App.OpenDoc (vDocument.GetContent.String,"","")

set s=newdoc.Sheets(vSheet.GetContent.String)

  1. s.Activate

end Sub

vDocument contains the name of the new document

and vSheet contains the id of the sheet to activate

I can walk on water when it freezes
4 Replies
Not applicable

Hi,

Have you tried opening the document using the IE Plugin for QlikView?

-Khaled.

ali_hijazi
Partner - Master II
Partner - Master II
Author

so you mean macros are only for IE with IE plug in?

what if users want to use google chrome for example?

I can walk on water when it freezes
IAMDV
Luminary Alumni
Luminary Alumni

Hi Ali,

Which client are you using for deployment? I'm assuming you are using AJAX client right? Are you going to activate the same sheet everytime users clicks this button? If it's same sheet then you can use in-built trigger instead of macro along with document chaining. Document chaining works very well with the AJAX client but have you thought about the implications of CAL assignment as you are spanning more than one document. Again, I'm assuming that you are using Name CAL hence you are jumping between the documents. Please give detailed information about what your actual requirement and one of us can provide you robust solution.

I hope this helps!

Cheers,

DV

www.QlikShare.com

ali_hijazi
Partner - Master II
Partner - Master II
Author

Yes users prefer using Google Chrome and FireFox

IE sucks

Yes I have 2 sheets to activate depending on which button the user clicks on the first document

Ok yes there is a built in Action to Open another document but there is not action to activate that sheet(s) of the second document

I can walk on water when it freezes