topic opening other document in QlikView

opening other document

Mon, 05 Dec 2011 05:07:59 GMT

Hi ALL,

I am having one qvw file in which I am having some buttons.

My requirement is when I click on button, new qvw file should open with required sheet.

For eg. when I click on button sales, new qvw file having sheet sales should open.

Can anyone help me regarding this?

opening other document

Mon, 05 Dec 2011 07:08:53 GMT

right click on the sheet -> Button -> on general tab give the name of the buttin -> on actions tab click add -> select external -> select open qlikview document -> click ok -> provide document path/ url.

when you click the button your document gets launch whose path you have provided in document path/ url.

opening other document

Mon, 05 Dec 2011 09:12:32 GMT

Hi Vijit,

This point I know but after opening document I need to opened the particular sheet..

My document might have many sheets. So when I click on Sales button,sales sheet in other document should opend.. Like I have 10 buttons so other document have 10 sheets correspond to buttons.

I hope you got my point..

Re: opening other document

marco_81 — Sat, 03 Nov 2012 08:42:41 GMT

Do you find a Solution meanwhile ?!
I have the same Problem then you... i want that on a click on the button an sheet will open with a special sheet id.

Re: opening other document

jagan — Sat, 03 Nov 2012 10:12:45 GMT

Hi,

Use this macro to open a qlikview file and correspoding sheet

sub xyz()

set app=activedocument.getapplication

set newdoc=app.opendoc("Test.qvw","","")

newdoc.activatesheetbyid "SH02"

end sub

Also, check attached files for solution.

Regards,

jagan.

Re: opening other document

marco_81 — Sat, 03 Nov 2012 10:45:00 GMT

Thanks... in Full Client the Makro works, but not in Ajax Client

... i have change the Button to "open URL" and open the URL

http://servername/QvAJAXZfc/opendoc.htm?document=Distribution/report.qvw&sheet=SH07

and that works first for me.