AJAX and URL parameters

[Alexander_Thor]

Sometimes you want QlikView to open with a specific set of selections, apply a bookmark or perhaps even deep link to a specific sheet.

A typical use case could be to embed an entire app or a single object inside a CRM or ERP system and depending on the context, current customer for example, filter the QlikView app to only show records related to that specific context.

So how do I use this black magic?

One approach would be to use triggers with the obvious downside being that the trigger would always fire regardless of how you opened the app.

Another approach is to supply a set of parameters to the URL for that specific app.

Let’s take an example, the Sales Compass demo from the demo site. Below us the URL to access the app and the different components explained.

Actual URL

demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FSales%20Compass.qvw&host=demo11

Explained URL

<host name>/<virtual directory>/opendoc.htm?document=<url encoded full name for the application>&host=<name of QVS>

In addition to this URL you can also supply some extra parameters to control which actions will fire when the app is opened. For example the URL below will open the Sales Compass app with the value “Q2” selected in the listbox with id LB5699 (yes we create way to many objects )

demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FSales%20Compass.qvw&host=demo11&select=LB5699,Q2

Of course this is only a simple example, in the table below you will find all the available parameters you can append to your URL.

Feel free to mix and match these til your hearts content.

Action	Parameter	Example
Select a single value	&select=<Listbox ID>,<Value>	&select=LB01,Total
Select multiple values	&select=<Listbox ID,(Value|Value2)	&select=LB02,(2011|2012)
Open the app on a specific sheet	&sheet=<Sheet ID>	&sheet=SH01
Open the app with a bookmark applied	&bookmark=<Bookmark ID>	&bookmark=Server\BM01

Wait a minute, you mentioned single objects?

Ah, yes! When QlikView 11 was launched we also introduced the capability to display a single object from an app.

This allowed customers to integrate objects from different applications into a single view in a external system. It is also this screen that powers the small devices client.

Substitute opendoc.htm with singleobject.htm and specify the object id you want to display,

demo.qlik.com/QvAJAXZfc/singleobject.htm?document=qvdocs%2FSales%20Compass.qvw&host=demo11&object=CH378

And voila! You now have a fully interactive single QlikView object!

[#2]

Awesome post...

[#3]

Hi Alexander -

Is there any way to transfer all of the selections made by the user, essentially replicating "Transfer State" functionality?

[cheburashka]

Hello,

I would like to open a document and send 1M+ disctinct values from one dimension/listbox across. I've tried this with the OPEN URL action and select=LBXX.

I assume there is a limit on the amount of values you can send along with the URL?

Any other ideas? I want one qlikview document that is on the accesspoint to be able to open another Qlikview document wich is also on the accesspoint.

,Thx in advance

[rwunderlich]

How about using the Open Qlikview Document action instead of Open URL?

[arieidel]

You have to do a Document Chain to open a QVW from another QVW and passing it the current selection (it do that through a temporary bookmark)

[cheburashka]

Hello,

How does the "Open Qlikview document" action work? When I use the action on a Qlikview developer client it will open document 2 locally and when I use that action on the accesspoint it will open document 2 in the accesspoint?

,KR Koen

[rwunderlich]

Hi Koen,

Yes, when used in the Access Point. "Open in Document" will open the document in the browser.

Note that the passing State (selections) to an already opened document has been a bit flaky. As of about SR7, it still did not work in the desktop but it does work on the server.

-Rob

[#9]

Hi Everyone,

     Anyway we can do this type of URL filtering with Qlik Sense? Got the server installed!

Thanks!

[kanhomcake]

hi Alexander,

Million thanks for your blog! it's BRILLIANT!!!!

Only my one further question, can we also pass parameters on to Variables?

Again thank you so much for your very useful blog

wv

[shree909]

Hi Alexander

I am trying to figure out is there something similar in qliksense to call the  bookmarks and charts with their OBJECT Ids.

I have a scenario where the users want to access the bookmark id directly with the url..

Calling the Bookmarks in the qliksense with a url

Thanks