topic pass parameter (sheet) in url in QlikView

pass parameter (sheet) in url

jasonseril — Mon, 26 Jan 2026 18:19:17 GMT

Good day to all,

Is it possible to pass parameter (the name of sheet) in url, so that when qvw document is opened in AP, the specified sheet will be opened. thanks in advanc e.

jason

pass parameter (sheet) in url

disqr_rm — Fri, 06 Nov 2009 22:47:03 GMT

Yes very well possible. You would create a variable in your document and fill this variable passing parameters in the url for this variable. Then "On Open" macro you would read this variable contents and activate the sheet you want. Make sure to wipe the contents out in the same macro, and put a check in the begining to make sure variable is not initial.

Hope this will help.

pass parameter (sheet) in url

jasonseril — Mon, 09 Nov 2009 07:29:47 GMT

Thank you very much Rakesh. Do you have a sample application for this?

jason

pass parameter (sheet) in url

deepakk — Mon, 17 May 2010 19:57:08 GMT

it doesnt workin in Qlikview 9 using Access point.

Please share you view on this.

pass parameter (sheet) in url

Fri, 28 May 2010 19:09:14 GMT

1. Create a variable in your Document and set the value to 0.
2. Create this procedute:

Sub WhenOpen

set v = ActiveDocument.GetVariable("vSheet")
ActiveDocument.Sheets(v.GetContent.String).Activate

End Sub

3. Create a Trigger OnOpen on Document Event Triggers to run the procedure.
4. The url is qvp://localhost/MyApp.qvw?vSheet=0, where vSheet is an array. So your first sheet is 0, the second is 1...

pass parameter (sheet) in url

tseebach — Sat, 20 Nov 2010 15:05:00 GMT

Hi,

There is a difference between doing this in Ajax and IE/Desktop. For the Windows Desktop & Plugin versions you can use the qvp:// protocal to pass a parameter. This would look like: qvp://servername/document.qvw?var=1&var=2

If you use Ajax, the only way I've been able to this is via bookmarks. If you select Remember Layout state in a new bookmark, then it will show the sheet you were on when it was created. And you can the reference the bookmark in the url by appending: &bookmark=Document\BM01

You will need to do a bookmark for each sheet you want to reference.

The bookmark method will also work in IE.

Support for setting variables via http urls would be really nice...

Regards Seebach

pass parameter (sheet) in url

amien — Fri, 29 Apr 2011 17:01:51 GMT

Thanks Torben!

Re: pass parameter (sheet) in url

Anonymous — Mon, 12 Aug 2013 09:41:07 GMT

@Torben Seebach

your tip works only if you creat a shared bookmark using the access point, but if you will creat a bookmark in the document using a desktop client it doesnt work.

Re: pass parameter (sheet) in url

arieidel — Wed, 30 Oct 2013 20:14:34 GMT

You can access directly to a specific sheet of your QVW by using de parameter "sheet" in the URL, like this:

http://servername/QvAJAXZfc/opendoc.htm?document=MyApp.qvw&sheet=MY_SHEET

Where MY_SHEET is the ID of the Sheet you want be open.

Regards,

Ariel

Re: pass parameter (sheet) in url

salto — Thu, 31 Oct 2013 08:03:39 GMT

As far as I know, Rakesh's solution is correct. I am using it in some of my reports, with the desired results (a trigger in the "On Open" event that activates the sheet).

Regards.

Re: pass parameter (sheet) in url

bnichol — Tue, 18 Mar 2014 16:41:24 GMT

Ariel,

Thanks, the AJAX solution works well.

Is there a similar solution for the IE Plug-in, othere than the on open trigger solution outlined?

Regards,

Re: pass parameter (sheet) in url

Bill_Britt — Tue, 18 Mar 2014 17:09:30 GMT

Hi,

No, the Plugin doesn't support that.

Bill

Re: pass parameter (sheet) in url

bnichol — Tue, 18 Mar 2014 17:36:28 GMT

Thanks for the confirmation about the IE Plug-in.

Re: pass parameter (sheet) in url

arieidel — Tue, 18 Mar 2014 17:54:17 GMT

A workaround for the plugin is using a Document or Server Bookmark.

You can create a bookmark saving only the layout (the sheet you want to open) and then pass it as a param, like this:

http://servername/Qvplugin/opendoc.htm?document=MyApp.qvw?bookmark=Server\BM1234

Hope it helps!

Re: pass parameter (sheet) in url

bnichol — Fri, 21 Mar 2014 16:33:13 GMT

Ariel,

Thanks for the bookmark suggestion. It works well with the IE Plug-in.

Regards,

Re: Re: pass parameter (sheet) in url

adiarnon — Tue, 26 Aug 2014 07:18:46 GMT

hi im using the IE plug in

is there any way to pass parameters?

"Is there a similar solution for the IE Plug-in, othere than the on open trigger solution outlined?"

what is the -open trigger solution outlined??

tnx

adi

Re: pass parameter (sheet) in url

adiarnon — Sun, 31 Aug 2014 07:29:30 GMT

can you explain how its works with the IE Plug-in??

i tried with no succes.

can you show your link?

Re: pass parameter (sheet) in url

Fri, 05 Sep 2014 08:53:05 GMT

Adi,

Server bookmark can be used and then use it in the url

Re: pass parameter (sheet) in url

prem_1961 — Mon, 25 Apr 2022 19:02:54 GMT

How to use it in QLIK Sense

Re: pass parameter (sheet) in url

Albert_Candelario — Tue, 26 Apr 2022 10:48:33 GMT

Hello @prem_1961,

I would suggest to raise the question on a new post on the Qlik Sense forum if you could not find the answer in the meantime.

Cheers!