Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Open another QVW file and activate a sheet.

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

1 Solution

Accepted Solutions
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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/

View solution in original post

9 Replies
tanelry
Partner - Creator II
Partner - Creator II

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
Contributor III
Contributor III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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/

Not applicable

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
Partner Ambassador
Partner Ambassador

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Creator III
Partner - Creator III

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.

Not applicable

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
Master III
Master III

Please start a new topic for a new question.

Topic locked.

May you live in interesting times!