Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Document Chaining in Qlik Sense

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykakkar93
Specialist III
Specialist III

Document Chaining in Qlik Sense

Last Update:

Oct 16, 2018 4:53:40 AM

Updated By:

ajaykakkar93

Created date:

Oct 16, 2018 4:53:40 AM

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
juraj_misina
Luminary Alumni
Luminary Alumni

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
Specialist III
Specialist III

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
Luminary Alumni
Luminary Alumni

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

0 Likes
Dalton_Ruer
Support
Support

Love it. This works fantastically. 

0 Likes
rh205bip
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
rh205bip
Contributor
Contributor

*Update

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

0 Likes
psankepalli
Partner - Creator III
Partner - Creator III

Excellent article 

0 Likes
ajaykakkar93
Specialist III
Specialist III

0 Likes
SergeyN
Contributor III
Contributor III

I do not understand why reinvent the wheel?
Use ODAG

0 Likes
ajaykakkar93
Specialist III
Specialist III

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

Version history
Last update:
‎2018-10-16 04:53 AM
Updated by: