Toggle Between multiple QVW

[#1]

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

[Miguel_Angel_Baeyens]

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

[#3]

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