Open another QVW file and activate a sheet.

[phaneendra_kunc]

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

[tanelry]

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

[natebrunner]

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.

[stevedark · Accepted solution]

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

Hope that helps.

Steve

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

[#5]

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

[michael_maeuser]

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

[stevedark]

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

[neetu_singh]

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.

[#9]

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.

[oknotsen]

Please start a new topic for a new question.

Topic locked.