topic Toggle Between multiple QVW in QlikView

Toggle Between multiple QVW

Thu, 20 Oct 2011 20:22:27 GMT

Hi all,

I am using this macro to link two QVWs suppose A.qvw and B.qvw. What I am doing is from A.qvw if we click on one of the sheet we are opening B.qvw and vice versa. Both A and B are working perfectly in the client(designer) View but it doesnot work in ACCESSPOINT . Why is it not working on accesspoint??

Sub OpenA

set App=ActiveDocument.GetApplication

App.OpenDoc "A.qvw","",""

ActiveDocument.Save

End Sub

Please help.

Thank you,

Abha

Toggle Between multiple QVW

Miguel_Angel_Baeyens — Thu, 20 Oct 2011 20:47:35 GMT

Hi Abha,

By Accesspoint do you mean the Ajax Zfp client, the IE Plugin or both? Some macros are not executed on server, and some of them will not work on the Ajax client when that means accessing the filesystem (OnActivateSheet, likely, sending an email, opening a file...)

Make sure, just in case, you are allowing unsafe macros in the server using the QEMC, System, Setup, QlikView Servers, Security.

Besides, the .Save action shouldn't work by design. As I mentioned above when you access a document via client - server some actions cannot be performed (edit script, save, reload, among many others) but they will work just fine in a local environment (using Desktop opening the file using File menu, Open instead of Open In Server).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Toggle Between multiple QVW

Tue, 25 Oct 2011 13:35:57 GMT

Hi Miguel,

Thank you for your answer. I had already checked both options: Allow macro execution on server and Allow unsafe macro execution on server using the QEMC, System, Setup, QlikView Servers, Security. But it still doesnot allow above macro to move between two qvws in accesspoint. Is there any way by which I can move from one qvw to another without coming back to accesspoint time after time. Please suggest.

Thank you,

Abha