Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Document Chaining in Qlik Sense

ajaykakkar93
Contributor

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

ajaykakkar93
Contributor

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
rh205bip
New 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
rh205bip
New Contributor

*Update

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

0 Likes
psankepalli
Contributor III

Excellent article 

0 Likes
ajaykakkar93
Contributor

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