topic Re: how to navigate between documents QlikView in QlikView

how to navigate between documents QlikView

Anonymous — Fri, 21 Feb 2014 10:16:26 GMT

hi, I have 2 documents open in QlikView how do I switch from one to another from macro ( Api )?

Thanks

Re: how to navigate between documents QlikView

Siva_Sankar — Fri, 21 Feb 2014 10:18:29 GMT

To swich from one qlikview tab or sheet to another, you can use the following.

Sub SwitchTab
For x = 0 to 5
ActiveDocument.ActivateSheet x
ActiveDocument.GetApplication.Sleep 1000
ActiveDocument.GetApplication.WaitForIdle
next
End Sub

Regards.

siva

Re: how to navigate between documents QlikView

Colin-Albert — Fri, 21 Feb 2014 10:20:07 GMT

Use an action button or an action on a text object. You do not need a macro to navigate between documents.

Re: how to navigate between documents QlikView

MK_QSL — Fri, 21 Feb 2014 10:27:45 GMT

Please find the enclosed file.

Hope this help.

Re: how to navigate between documents QlikView

Anonymous — Fri, 21 Feb 2014 10:28:28 GMT

I have 2 documents opened and I want to write a code same to the action that you execute when you press window in the Qlik view menu.

sorry for my english

Re: how to navigate between documents QlikView

Anonymous — Fri, 21 Feb 2014 10:35:07 GMT

I want to navigate between 2 documents qvw not between 2 sheets

Re: how to navigate between documents QlikView

Anonymous — Fri, 21 Feb 2014 10:36:41 GMT

I have to use a code because I have to do this from VB (external code)

Re: how to navigate between documents QlikView

kaushiknsolanki — Fri, 21 Feb 2014 11:06:49 GMT

Hi,

You dont need to have the macro to do this.

Instead you can use the "Open QlikView Document" action available under "External" option in Action Tab of a button.

On one of the document (Say A)you can place the button with this action to open other document(Say B).

Do the vice verse for the document B.

Regards,

Kaushik Solanki

Re: how to navigate between documents QlikView

Anonymous — Fri, 21 Feb 2014 11:14:00 GMT

I have to use a code because I have to do this from VB (external code),

and I know that I could use OpenDoc or openDocEx but if my document is opened why I have to go over all the credentials to open it again? (username, password, etc. ..)

thank

Re: how to navigate between documents QlikView

kaushiknsolanki — Tue, 25 Feb 2014 09:47:06 GMT

Hi,

No if the document is open you don't need to give any credentials.

Regards,

Kaushik Solanki

Re: how to navigate between documents QlikView

Anonymous — Tue, 25 Feb 2014 09:58:06 GMT

so I have to run another opendoc?