topic Re: opening another document in QlikView

opening another document

ali_hijazi — Sat, 10 Nov 2012 09:28:10 GMT

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)

s.Activate

end Sub

vDocument contains the name of the new document

and vSheet contains the id of the sheet to activate

Re: opening another document

Sat, 10 Nov 2012 10:12:31 GMT

Hi,

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

-Khaled.

Re: opening another document

ali_hijazi — Sat, 10 Nov 2012 17:49:53 GMT

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

what if users want to use google chrome for example?

Re: opening another document

IAMDV — Sun, 11 Nov 2012 00:24:14 GMT

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,

www.QlikShare.com

Re: opening another document

ali_hijazi — Sun, 11 Nov 2012 13:30:27 GMT

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