topic Re: How to open another qvw file on server by using macro in QlikView

How to open another qvw file on server by using macro

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone

I have a test macro like this

set App = ActiveDocument.GetApplication

set newdoc = App.OpenDoc ("qvp://<MYSERVER>/<MYDOCUMENT>.qvw)

it can call another qlikview applicaiton locally but doesn't work on Access Point

i also tried

set newdoc = App.OpenDoc ("qvp://123.57.xx.xxx/<MYDOCUMENT>.qvw)

but i got same problem

i can't use the trigger function "Open Qlikview Document" for some seasons

and it seems can't be set on Field Event Triggers ( i tried and i failed)

this is very very urgent , any answer will be appreciated , please please help me !!

thank you in advance

Re: How to open another qvw file on server by using macro

tamilarasu — Sun, 12 Jun 2016 05:19:39 GMT

Hi Dave

I have not tried this before. Below link might be helpful.

Open another QlikView Document on click of a button

Re: How to open another qvw file on server by using macro

woshua5550 — Sun, 12 Jun 2016 05:39:46 GMT

Thank you Tamil

I know about this , but the problem is that "Open Qlikview Document" is not available for field event triggers

I need to trigger it by clicking on my straight table's dimension , i don't want to use a button

so i suppose i must do it by macro and now i realize maybe "OpenDoc" is not available on Web too..

Re: How to open another qvw file on server by using macro

phaneendra_kunc — Sun, 12 Jun 2016 06:16:37 GMT

Are you using IE plugin ? Macros only work in IE plugin or desktop.

is your macro works on desktop?

What is your real requirement? just to open a document from another QVW? if so you can achieve through actions. May be i am missing something here. Please elaborate your issue using actions.

Search for "Document Chaining" in community you will find tons of answers.

Re: How to open another qvw file on server by using macro

woshua5550 — Sun, 12 Jun 2016 08:25:52 GMT

Hi Phaneendra

Yes my macro works on desktop , it can't work on IE plugin and Full Browser version

let me put it on this way

i have two documents A.qvw and B.qvw

A.qvw has two sheets (let's say sheet1 and sheet2) and both sheets have a listbox which shown Field "name"

B.qvw has two sheets too

all i want is that if i select a "name" in sheet1(A.qvw) then i go to B.qvw sheet1

also if i select a "name" in sheet2(A.qvw) then i go to B.qvw sheet2

all the state should be transfer

I want it works on Access Point

I tried to set "Open Qlikview Document" action to "name" but nothing happend

if i set the action into a button , it can works well

but i suppose i can't specific which sheet should be active after i turned to B.qvw

Re: How to open another qvw file on server by using macro

phaneendra_kunc — Sun, 12 Jun 2016 14:36:28 GMT

Hmmm... You are looking for a field event trigger.. Let me try. I don't think that is possible by let me see if there are any other alternative ways.

But you are good to use IE plugin? Or just for this sake of this functionality you are using IE PLUGIN?

Phaneendra Kunche

BI Developer

Symphony Health Solutions

2390 E. Camelback Road<x-apple-data-detectors://1/0>

Phoenix, AZ 85016<x-apple-data-detectors://1/0>

Re: How to open another qvw file on server by using macro

woshua5550 — Mon, 13 Jun 2016 07:57:04 GMT

Hello Phaneendra

if you have a solution,plz let me know

is this the IE plugin you said? actually i don't like it and my macro doesn't work at here too

but if a solution must to use it , it can be a option

Thank you very much