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!

[brindlogcool]

In QlikView SR12 the encoding is not happening properly. It is allowing only one parameter. it is dropping the second parameter. Any suggestions

[Bill_Britt]

Hi,

I have just tested this and it works for me.

http://localhost/QvAJAXZfc/opendoc.htm?document=Films.qvw&host=QVS%40lab12&select=LB1457,"Abel Ferrara"&select=LB1459,Aadil

Bill

[brindlogcool]

Thanks Bill . It works fine when i manually use it.

Sorry for not providing the clear details. We are using it with the webticket .

Based on fiddler logs

Request url

https://test.com/QvAJAXZfc/Authenticate.aspx?type=html&webticket=ZCFs53bIcLxRMMAU1kuhQLlvZBn5U4YjmBT...

Response url

After authentication it shows as

https://test.com/QvAJAXZfc/opendoc.htm?document=test/aaa%20p%201iw%20tro.qvw&select=LB22%2C1%2CLB70%2C180

You can see the difference in the response url the selection parameters are encoded and select keyword is missing for the second list box.

so again it was perfectly working fine in SR5 (both the selection parameters are working) but not in SR12 (Only the first parameter works the second parameter is not working). trying to find how the selection parameters are encoded and why the select keyword is dropping.

Any suggestions on how to fix it.

[#5]

Hi Alex,

I see that new features have been added to Qlikview mobile ios app recently.

What's New in Version 2.3.0

- iOS9 support
- Support for URL scheme to communicate with the app from other native apps or links on web pages (online or offline)

I couldn't find any support document for the second feature added. What URL changes are required to open dashboard in ios mobile app with predefined selections from another web page?

Thanks,

Anosh

[sarahallen1]

When passing selections into the URL, it seems to use them as a search string rather than an exact match.  E.g. I have

select=LB86,"ABC"

and this doesn't work as it returns ABC, ABCD and ABCE (and the chart I want needs a single selection). 

I have changed LB86's search from wildcard to normal but that didn't change it.

Does anybody know how to get an exact match like this?

Thanks,

Sarah

[blaise]

i do not have a test env to test this but i guess that the URL and passing selections works the same way as an action. Instead of passing "ABC" can you try with "(ABC)" ?

I use () when i want to select multiple values, f.ex. (ABC|ABCD) as the search string on a select in field action.

Changing the "default search mode" on a listbox to "wildcard search" does not change the way qlikview make searches, it just add two * to the search box when pressing the search button.

[sarahallen1]

Thanks Johan.  Unfortunately that doesn't work, but I did find a workaround at the bottom of this post: Re: AJAX URL Selection Parameters - Select Literals

Thanks.

[arieidel]

Hello Sarah,

To get an exact match of that value you should use ( and ), like:

select=LB86,(ABC)

Hope it helps!

Ariel

[sarahallen1]

Thanks Ariel, for some reason the (ABC) notation is not working, it still gives multiple selections.  Thank you though

[arieidel]

That's strange! I had the same issue and it was solved for me using the ( and ).