opening other document

[#1]

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?

[#2]

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.

[#3]

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..

[marco_81]

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.

[jagan]

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.

[marco_81]

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.