topic Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc. in QlikView

URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Mon, 26 Jan 2026 16:26:21 GMT

You may be aware, that you can pass additional query strings when opening a QlikView app from the AccessPoint in order to pass field selections or bookmarks, to open a desired Worksheet or just one object instead of the entire app.

something like

http://server/QvAJAXZfc/opendoc.htm?document=app.qvw&select=LB01,2013&sheet=SH02

There is good documentation around, for example by Stefan Walther here QlikView Mashups - Simple Document Integration

However, getting the syntax right can be quite challenging.

This little tool will help you compute the proper URL in a simple manner, as at the end you just make selections and the tool will compute the corresponding url and all querystrings automatically.

Download the attached QVW
Copy all its objects to a new sheet in your app (in that app, which you like to create the url for)
Copy some lines of source code from the top text object into the load script of that app
Reload that app.
Now you just make the selections in the frontend as usual and return to the new sheet.
Select, which of your selection you will like to add to the url
Optionally make some more settings (bookmarks, target sheet, single object ...)
You can see, copy, and click the complete URL at the bottom of the sheet

If you want to see a how-to.use videos check this:

Tutorial Video (Flash Video), attached
Behind the curtains (Flash Video), attached

New Version v1.12 (24-Oct-13) is using the syntax select=LBxx,(value1|value2|valueN) instead of select=LBxx,value1,value2,valueN ... this simply works better and allows to pass wildcards, too 😉

Hint:

Create a new bookmark with no selections at all. Use this bookmark together with the selections in the URL. This will force the app to first clear all selections (via the bookmark) and then to add the passed selections. Otherwise the passed selections come on top of the current selections (last saved selections or the user selections made during the current session)

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Anonymous — Fri, 05 Dec 2014 09:00:51 GMT

It's awsome.

Really hats of man.

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

cheburashka — Thu, 05 Mar 2015 14:04:58 GMT

Great post and app

Though I recommend to tag your post. It took me a while before I bumped on this post.

,KR Koen

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

martyginqo — Sat, 07 Mar 2015 01:15:44 GMT

Thank-you for the creative work. We have used this and other solutions that you've provided.

We're hitting a little snag in that this spawns a new browser tab...and if we stay within the same document, then the two documents eventually conflict. Is there a way to force the resultant hyperlink to stay in the same window. I'd like to author my own HTML to solve, but currently resigned to <url> methodology.

<update>This is now more a curiosity, as we're using triggers to solve the use case.

Thanks again.

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Wed, 11 Mar 2015 19:42:21 GMT

Hi. There is a Document Extension which will redirect ALL hyperlinks inside of a QlikView app to "_self", so to the same browser tab, not opening a new one each time. I am afraid, this is then global for the whole app, not depending on some URLs to stay in the same window, some to open in another tab ...The extension is called "OnlySelf" and consists of only 2 files which are in the .ZIP. Unpack those into this folder

C:\Users\<youruser>\AppData\Local\QlikTech\QlikView\Extensions\Document\OnlySelf

(Create necessary folders if they do not yet exist. if this is your first Extension, the entire Extension subfolder tree will not be present).

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Thu, 19 Mar 2015 20:52:40 GMT

hi, This is fantastic.

However, Im trying to get the equivalent to work using IE plug in. Is there a solution for this?

Many thanks,

Tom

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Fri, 20 Mar 2015 12:20:27 GMT

With IE Plug-In those URLs would not work. Are you trying to achieve QlikView App chaining (link from one app to the other) or to jump from anywhere in your intranet to the QlikView Accesspoint and set fields, bookmarks, sheets just like with the Ajax-client?

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Fri, 20 Mar 2015 14:50:10 GMT

Hi, thanks for your reply.

I'm trying to go from one app to another. Both apps are in accesspoint and I need to pass document selections from the first app to the second - with the IE plug in rather than using AJAX.

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Fri, 20 Mar 2015 15:47:19 GMT

Are those apps in a similar structure? you then may use an action (in a button or textbox) called "Open QlikView Document" with the setting "Transfer State"

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Fri, 20 Mar 2015 16:13:23 GMT

hi they are in a similar structure ( they are both test apps and therefore copies of each other)

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

swuehl — Tue, 28 Apr 2015 09:18:48 GMT

Hi Christoph,

is there any way to open a QV app with parameter using IE plugin Client in the second scenario ("...from anywhere in your intranet to the QlikView Accesspoint and set fields, bookmarks, sheets just like with the Ajax-Client")?

For example, creating a PDF with links to the application (for looking up details), opening the app in IE plugin Client with parameters passed?

Regards,

Stefan

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Wed, 29 Apr 2015 07:46:49 GMT

I am afraid there is no such link to directly open sheets and make selections when using the IE Plugin. You may find an alternative using the full QlikView Desktop on your Client computers, which accepts command line options when being opened. Those, again, could be used in combination with a Document OnOpen Trigger to do something with this variable.

This example

"c:\Program Files\qlikview\qv.exe" c:\test.qvw /vvCallBookmark=BM01

Would set the application variable “vCallBookmark” to “BM01”

In combination with the following trigger you can then apply the bookmark. You could use other actions as well such as “Select In Field” or “Open Sheet” …

Just an idea …

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

arkossa-jpl — Sat, 13 Jun 2015 11:25:48 GMT

Really cool a well explained technique.

Thanks a lot!

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Tue, 08 Dec 2015 19:20:47 GMT

Hi Chris,

How to clear the selection whichever made in previous sessions. I want the previous selections should get cleared out whenever i click the hyperlinks and the new selections should be based on the URL parameters. Could you please help me ?

Thanks

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Anonymous — Wed, 16 Dec 2015 19:39:31 GMT

Hi Chris, does it work with variables? i mean setting variable values on the destination qvw.

Thanks!

Dai

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Fri, 29 Jan 2016 14:24:22 GMT

HI All,

Could you tell me the syntax of passing variable from one QVW to Other QVW file, Just like did for Selections?

means what I need to write at the end of URL. eg. & SET Variable=vVariable,0.....

Thanks Allot!,

Bhuvan

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Fri, 29 Jan 2016 21:03:53 GMT

‌hi. The answr is simple and you wont like it,: variables cannot be passed through a URL querystring. I have read from people to achieve this indirectly via a data island field, which has all of thpossible variable values. By URL you set the value of that field and because of a field trigger you will set the variable indirectly. Havent done this myself Though.

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Mon, 01 Feb 2016 05:38:48 GMT

Hi Christof,

Thanks allot for reply.

Do you have any idea, whether we can pass variable by using Bookmark or not.

Thanks Allot!,

Bhuvan

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

ChristofSchwarz — Mon, 01 Feb 2016 16:27:54 GMT

You can set a variable to be stored in bookmarks. By default this is not the case (recalling a bookmark usually doesnt change any session variable). If you save a variable together with a bookmark, the variable willa slo be recalled. However, a bookmark can only recall what was the value at the point of creating the bookmark. So you cannot pass somthing at all using bookmarks, as the selections and maybe some defined variables will just recall, not get a value of choice.

Von meinem iPad gesendet

Am 01.02.2016 um 07:57 schrieb bhuvan bharti <qcwebmaster@qlikview.com<mailto:qcwebmaster@qlikview.com>>:

Re: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Tue, 02 Feb 2016 05:00:21 GMT

Hi Christof,

Thanks for reply. I understood we can pass only filters by using URL, So what I did is I made inline and made it as hidden filter and based on that I changed the variable and then passed the selection using URL.

Thanks Allot for reply:)

Thanks Allot!,

Bhuvan