Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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..
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.
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.
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.