Qlik Community

Qlik Sense Documents & Videos

Documents & videos about Qlik Sense.

Document Chaining in Qlik Sense

Specialist
Specialist

Document Chaining in Qlik Sense

Document Chaining in Qlik Sense made simple.

As we all know in QlikView document chaining is drilling down from one application to another automatically transferring selections.

Qlik Sense does not have document chaining yet,but we can do this in two ways.

  1. We can make a extension that will do every thing for us it has all the property set (i'll leave my link to GITHUB for the same).
  2. Using a simple method/function GetCurrentSelections() in Qlik Sense

To make this possible i'll use the second method to get this action in your qlik sense application

  1. We are going to use Sheet Navigation + Actions for Qlik Sense
  2. Under Navigation Behavior -> Navigation Action -> Open website (uncheck Open in same window option)

    dc1.PNG

    Now open to make it happen open a application sheet in chrome browser, copy the url and add the below code


    ='Your_URL' & '/select/' & GetCurrentSelections('/select/','/',';')

So it will look somewhat like this


='http://exampleQsDev.com/sense/app/aak0-aa55-4ahwe/sheet/f0a33/state/analysis' & '/select/' & GetCurrentSelections('/select/','/',';')

NOW ADD THIS TO THE EXPRESSION OF Website Uri.


when you do your selection the rest of url is made using GetCurrentSelections() function


4th parameter for the GetCurrentSelections('/select/','/',';',200)


Visit : GetCurrentSelections to know more

I have noticed if selection is more than 5 or 6 it will not generate the link as we need for performing the actions.

I am planing to make a proper extension to make this happen but till then this is what we have.

Doc_chan.gif

Thank You,

Ajay Kakkar

ajaykakkar93@gmail.com

Qlik Sense Integration, Extensions and APIs

Comments
Luminary
Luminary

Hi,

Interesting use of GetCurrentSelections() function. I've made something similar, using Concat(). You can check it out here: App integration API - simplify analysis of large data volumes

Juraj

Specialist
Specialist

Yes that is a way but in my way there is a disadvantage if selection is more than 5 or 6 it will not generate the link.

I am planing to make a proper extension to make this happen but till then this is what we have.

0 Likes
Luminary
Luminary

I think you can handle this with fourth paramemter for the GetCurrentSelections function.

0 Likes
Employee
Employee

Love it. This works fantastically. 

0 Likes
Contributor
Contributor

 Hi,

Its al working great, but....something weird is going on with Month (Maand) field.

All fields get selected in the app that I open from the button, except the Month field.

This is my url: ...sense/app/{appid}/sheet/{sheetid}/state/analysis/select/Maand/jan/select/Jaar/2018

Jaar (Year) is selected, Maand isn't...Ideas?

 

0 Likes
Contributor
Contributor

*Update

I swapped the monthfield from month tot monthnumber..somehow that works.

0 Likes
Partner
Partner

Excellent article 

0 Likes
Specialist
Specialist

0 Likes
Contributor III
Contributor III

I do not understand why reinvent the wheel?
Use ODAG

0 Likes
Specialist
Specialist

This is one of the ways we can do it @SergeyN .

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2018-10-16 04:53 AM
Updated by: