topic Re: Passing Parameters in a URL and Document Chaining in QlikView

Passing Parameters in a URL and Document Chaining

Josh_Good — Fri, 18 May 2012 22:31:02 GMT

This videos describes how to pass parameters in a URL and how to leverage this techinque to chain documents when using AJAX.

The genral syntax is as follows:

http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,Value

It is also possible to us a similar technique to go directly to a specific sheet within a document using the sheet parameter.

e.g. http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&sheet=SH01

http://youtu.be/ESSvm_xMTlE

Re: Passing Parameters in a URL and Document Chaining

harvinderjohal — Thu, 20 Sep 2012 21:52:41 GMT

For linking to or selecting Bookmarks via URL, within QlikView Desktop, you can make selections, save as bookmark, and can reference this bookmark via URL. This is effectively a form of parameter passing but instead of passing data values via a URL, you are really only passing selection values...and security is still maintained within QlikView.

The syntax for Document Bookmarks is: &Bookmark=Document\BM01

Such as in the case of this full URL example (this link is not active, it is only an example of syntax): http://localhost/QvAJAXZfc/opendoc.htm?document=Web%20Deploy/Cartwright.qvw&host=Local&Bookmark=Document\BM01

Re: Passing Parameters in a URL and Document Chaining

AbhijitBansode — Mon, 04 Mar 2013 09:41:31 GMT

This is really good video for document chaining.

belwo are my couple of doubts:

1. How to supress "OnOpen" triggers of the second document.

Explanation:

the other document which I'm trying to open form first Qlikview documnet has Some triggers for "OnOpen" event.

These triggers includes: defaul selections, default sheet etc.,

but when I apply document chaining (when i open the other Qlikview documnet form first) these "OnOpen" triggers

should be bypass by the selections specififed in the URL of document chaining.

And when the second documnt if opened directly, the "OnOpen" triggers should work.

2. In above video, List Box selections is specified in querystring of the URL.

I want to select the data of the field which will be present in the multibox along with another fields.

So is there any way to specify fieldname with the multibox object?

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Mon, 04 Mar 2013 18:45:25 GMT

Hi,

If you use the "Open QlikView Docment" action (as opposed to the Open URL action) then you can activate the "Transfer State" checkbox. This will transfer all your selections from the first document to the second document. The down side of this approach is you don't have control over which selections are transferred. The up side is all selections are transferred so you don't need to guess what selection are going to be made in the first docoument.

This approach will also override any "OnOpen" selection made by the document.

I have included two QVWs. The button on Test1.qvw will open Test2.qvw. Note that Test2.qvw also has an OnOpen action to selection OrderYear = 2011 however this is overriden by the "Open QlikView Document" action coming from Test1.qvw

Re: Passing Parameters in a URL and Document Chaining

AbhijitBansode — Wed, 06 Mar 2013 12:12:55 GMT

Hi Josh,

Thanks for your time.

I can not use 'Open QlikView Documnet' trigger, because it will not alloow me to specify sheet name to open from another document.

Another QlikView document will have more than one sheet.

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Wed, 06 Mar 2013 15:57:45 GMT

Hi Sparten B,

I'm guessing you can't just have the target document saved to the correct sheet because are trying to use the target document for direct access (i.e. via Access Point) as well. The only other solution I can think of is to use the "Open QlikView Document" and add a data island to the data model of both QVWs that only purpose is to have the target document open on the correct sheet. My thinking is when you the user actions the target document to be openned a selection is made on the data island of the first document. Then when the selections get passed to the target document (which also has the same data island) you can use the selection to force the target document to go to the correct sheet.

Happy Qliking!

Josh

Re: Passing Parameters in a URL and Document Chaining

AbhijitBansode — Thu, 07 Mar 2013 13:14:19 GMT

I have saved another QlikView document with default sheet active.

When user make selections in first document, different sheets will be visible depending upon selections made.

Yes, cerating data islands to transfer selection state can be one of the solution for this.

Thank you.

Regards,

Sparten

Re: Passing Parameters in a URL and Document Chaining

Tue, 16 Apr 2013 15:36:52 GMT

Good video!

Is there a way we can activate a specific object on the sheet also? i mean go to a different QVW, specific sheet and maximise a specific object from the link?

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Tue, 16 Apr 2013 16:58:49 GMT

Not by passing a URL. I believe you can do it by creating an open document action. However that would apply to regardless of how the user entered the document.

Re: Passing Parameters in a URL and Document Chaining

jagannalla — Thu, 25 Apr 2013 08:30:32 GMT

Josh,

It is really helped me lot. But when I'm trying achive below functionality it is not working.

In second file I've a field with name Product the values of product is A, A1, A2, A21. When I tried the URL with suffix as

& select=LB02,A1,A2

The result it shows me at access point, Product with values A1,A2,A21. I didn't specified A21 in URL but still it shows me the selection in the file.

How can I overcome this.

Can you help on this.

Thanks,
Jagan

Re: Passing Parameters in a URL and Document Chaining

jagannalla — Thu, 25 Apr 2013 15:08:06 GMT

Josh,

It is working now. But I want to stop displaying all values of product in URL.

Say for example

Select=LB01,A1,A2,A3,A4,A5,,,,,,,,,,,,,,,,A100

Is it possible?

Thanks,

jagan

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Thu, 25 Apr 2013 15:20:02 GMT

Hi Jagan,

Can you please share how you resolve the issue so if someone else has the same problem they will know what to do.

If do not want to show the list then you could activate a bookmark in the target document. This will make your selection set fix thought. Your other option would be to use the Open Document action and transfer the state. The details on both of these is covered above.

Regards,

Josh

Re: Passing Parameters in a URL and Document Chaining

Wed, 31 Jul 2013 02:29:13 GMT

Hi Josh,

Do u know how to show the parameters DIRECTLY on Url ? Because I need to catch the parameters via url to do another program.

For example, when I select productID='AA01' in a listbox, then the url could show http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,"AA01"

Furthermore, If I could select many parameters(ex,productid,year,month,....) and ALL show on URL is better!!

Could it possible? please help!

Thanks a lot

Regards,

Nina

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Wed, 31 Jul 2013 21:29:38 GMT

Hi Nina,

As far as I know it is not possible to have the URL change as selections are made in the app.

-Josh

Re: Passing Parameters in a URL and Document Chaining

Thu, 03 Oct 2013 17:45:41 GMT

Hi, How did you fix the problem with the selection? I have a URL that has product_id where product_id is a number. If I do select=LB18,1 I'm getting all products that have a 1 (1, 10, 11, 110, etc.)

Any ideas?

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Thu, 03 Oct 2013 20:52:36 GMT

You need to use this style of notation (value|value). So you your case it would be:

select=LB18,(1)

select=LB18,(1|15|35) would select 1, 15, 35 only.

Re: Passing Parameters in a URL and Document Chaining

Thu, 03 Oct 2013 21:40:46 GMT

Thanks Josh!!!

Re: Passing Parameters in a URL and Document Chaining

ChristofSchwarz — Thu, 24 Oct 2013 07:26:28 GMT

Hi Josh. Cool explanation. Can you also pass a variable value in the querystring?

Together with QV11.2 SR4 the surprising behaviour of the "select=LBxx" has changed a bit. There shouldn't be multiple selections any more. The best syntax I have seen and tested so far is the one mentioned by you:

select=LBxx,(value1|value2|valuex)

Only a few things to mention: if the value in this list contains a space or a comma, you have to replace it with '?'. Sideeffect: This syntax allows to pass also '*' wildcards, for example

select=LBxx,(*) will select all

select=LBxx,(Josh*) will select all starting with Josh

select=LBxx,(*Good*|*Bad*) will select containing either Good or Bad

isn't this cool? I have created a URL composer which should make it easier for mortals to compute a valid querystring here: URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Re: Passing Parameters in a URL and Document Chaining

bill_mtc — Thu, 24 Oct 2013 08:14:38 GMT

Wow! Great tips. I'm looking for this a year ago.

Re: Passing Parameters in a URL and Document Chaining

Josh_Good — Thu, 24 Oct 2013 15:00:58 GMT

Thanks for the additional info Christof.