Skip to main content

Design

The Design blog is all about product and Qlik solutions, such as scripting, data modeling, visual design, extensions, best practices, and more!

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Alexander_Thor
Employee
Employee

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.

ActionParameterExample
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!

91 Comments
sarahallen1
Creator II
Creator II

OK thanks I'll check maybe something else is getting in the way of it working.  Thank you

0 Likes
839 Views
alexdataiq
Partner - Creator III
Partner - Creator III

Yeah, it also worked for me when using parentheses. Maybe the difference is that the fields in my application had spaces in the values. e.g.: CENTRAL, CENTRAL NORTH, CENTRAL SOUTH, etc...

So when we used &select=LB01,CENTRAL it selected all of the values above,

0 Likes
839 Views
Not applicable

Hi Alex,

I have a problem bookmark size above 32KB. Bookmarks of users in my organization are being discarded by Qlikview server.

We even called Qlik for a solution, they informed that this is the intended behavior of the Qlikview Server.

I'm planning to provide another workaround which works with Access Point URL assigned to a text object and included Ajax parameters.

If I go this way, will it be possible to include dynamic, multiple & complex selections using Ajax parameters ?

Awaiting your help.

0 Likes
839 Views
Not applicable

Hi Alex,

Is it possible to multiple selection criteria with different data types (Including comparison operators) into Ajax parameters ?

Awaiting your help.

Best Regards,
Sandeep S

0 Likes
839 Views
uacg0009
Partner - Specialist
Partner - Specialist

Because I used the Document bookmark, so if you want to applied a document bookmark, please use

&bookmark=Document\BM01

Aiolos

0 Likes
997 Views
ipsitasyngenta
Contributor II
Contributor II

Thanks Alexander for adding such a fantastic blog. Its very helpful.

I am wondering a way how can I specify a value of a defined dimension in an object.

As you explained about the opening of singleobject by specifying the object reference(Eg: &object=CH044), similarly lets assume the object has dimension as "Countries" and I want to display the sales data of America. Now how could I frame my URL to achieve this.

Ipsita

0 Likes
997 Views
ipsitasyngenta
Contributor II
Contributor II

Can anyone please reply. I wanted to know if there is a way to display a dimension value in URL or not.

Or Else we have to call the object in URL and do dynamic selection of dimension values.

Thanks,

Ipsita

0 Likes
997 Views
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Ipsita,

All you have to do is create a listbox with "Countries" as the field it uses. Give it a good ID (e.g. lb_Countries), then just add &select=lb_Countries,America to the end of the URL. It's usually a good idea to have a hidden sheet with a listbox for each dimension you want to add to the URL. This way you can select values for dimensions you might not have in the rest of your dashboard.

Hope this helps,

Jason

997 Views
ipsitasyngenta
Contributor II
Contributor II

Many Thanks Jason for advising a way around.

I got to know about few parameters like &object,&select,&sheet passing in URL to get desired output.

Is there any more list of parameter values which we can play around.

As Alexander explained about singleobject.htm in reference of object(CH044) to open a single object from URL hit.Similarly, it is possible to open two or more objects?

Please advice to learn more.

Thanks

Ipsita

0 Likes
997 Views
Jason_Michaelides
Luminary Alumni
Luminary Alumni

I don't think there's more than Alex lists above.

0 Likes
997 Views