Document Chaining in Qlik Sense

[ajaykakkar93]

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)

   

    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.

Thank You,

Ajay Kakkar

ajaykakkar93@gmail.com

Qlik Sense Integration, Extensions and APIs‌

[juraj_misina]

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]

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.

[juraj_misina]

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

[Dalton_Ruer]

Love it. This works fantastically. 

[rh205bip]

 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?

[rh205bip]

*Update

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

[psankepalli]

Excellent article 

[ajaykakkar93]

Thank You.. for you appreciation people..

[SergeyN]

I do not understand why reinvent the wheel?
Use ODAG

[ajaykakkar93]

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