topic Re: Open another QVW file and activate a sheet. in QlikView

Open another QVW file and activate a sheet.

phaneendra_kunc — Fri, 02 Mar 2012 15:36:47 GMT

Hi All,

I have situation where i have to keep a button in my first qvw file which which opens another qvw file and activates a sheet that i am intrested in second qvw file.

if some one is having a solution, please help me out...

Thanks,

phani

Re: Open another QVW file and activate a sheet.

tanelry — Mon, 05 Mar 2012 15:18:35 GMT

There is button action External > Open QlikView Document. But it won't activate specific sheet.

In a server solution you could also try Open URL. There you can enter other document address and modify the link to apply a bookmark on opening

(need to append: &bookmark=Document\BM01).

Re: Open another QVW file and activate a sheet.

natebrunner — Tue, 27 Nov 2012 16:19:12 GMT

So are we sure there is no way to activate a specific sheet? I can't believe they don't have this as an option yet.

Re: Open another QVW file and activate a sheet.

stevedark — Thu, 30 May 2013 10:30:33 GMT

If you are calling the Ajax (or Full Browser) version you can pass a parameter in for the sheet with this syntax:

&sheet=SH01

You can even pass in a selection for a list box (note you need to have the list box created - you can't reference a field):

&select=LB01,ValueToSelect

I would always recommend renaming any objects you are using in this way, so you could end up with a URL string such as this:

http://servername/QvAjaxZfc/opendoc.htm?document=System/QlikView%20Status%20Dashboard.qvw&host=localhost&select=TRIGGER,0&sheet=OVIEW

Hope that helps.

Steve

http://www.quickintelligence.co.uk/

Re: Open another QVW file and activate a sheet.

Mon, 02 Sep 2013 13:46:00 GMT

Hi Steve,

Your post is helpful but is there any way to set the specific variable value to 1 in the URL when i am opening the specific sheet of another qvw through Open URL link.

Thanks in Advance!!

Regards,

Monika

Re: Open another QVW file and activate a sheet.

michael_maeuser — Mon, 02 Sep 2013 13:51:56 GMT

this is the macro you need.

when you need another button to get another shee opened, just add this macro again and change the sheet id

SUB OpenSH09

set app=activedocument.getapplication

set newdoc=app.opendoc("C:\QlikView\Documents\Document.qvw","","")

newdoc.activatesheetbyid "SH09"

END SUB

Re: Open another QVW file and activate a sheet.

stevedark — Wed, 04 Sep 2013 12:07:45 GMT

Hi Monika,

As far as I am aware you can only set selections on fields in list boxes in the URL. You will see in my example URL that I have a field called TRIGGER - the reason for the naming is that I have an on-change event that notices when that field is changed and populates a Variable.

There may be a more elegant way of doing this - but I am not aware of one.

If you need assistance with setting up the trigger please post back.

Regards,

Steve

Re: Open another QVW file and activate a sheet.

neetu_singh — Wed, 04 Sep 2013 12:26:34 GMT

Hi,

In your first qvw, create a button and add action External -----> Open qlikview document -----> enter the path of second qvw.

For activate specific sheet, in second qvw goto document properties -----> trigger -----> select on open (click add action) ------> add----> select layout ----> activate sheet -----> mention sheet id which you want to activate on open.

hope it will help you out.

Re: Open another QVW file and activate a sheet.

Tue, 24 May 2016 14:20:00 GMT

Hi Brunner, did you get the solution to activate a specific sheet of one qvw from another?

I have a scenario, where i need to go to sheet1 of first.qvw from second.qvw. I have created a button and used action External -> 'Open Qlikview Document'

It is working fine, but not able to solve my purpose. Actually if I open first.qvw directly, it should open from 'Main Sheet' and if i need to open the first.qvw from another qvw, (Ex: second.qvw) it should go to 'Sheet1' instead 'Main' sheet

Please help me if you have a solution for my requirement. thank you for your time.

Re: Open another QVW file and activate a sheet.

oknotsen — Tue, 24 May 2016 14:28:15 GMT

Please start a new topic for a new question.

Topic locked.