Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
end Sub
vDocument contains the name of the new document
and vSheet contains the id of the sheet to activate
Hi,
Have you tried opening the document using the IE Plugin for QlikView?
-Khaled.
so you mean macros are only for IE with IE plug in?
what if users want to use google chrome for example?
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
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