Qlik Community

Ask a Question

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE

Document Chaining in Qlik Sense

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

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

0 Likes
Dalton_Ruer
Employee
Employee

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
Partner

Excellent article 

0 Likes
ajaykakkar93
Specialist
Specialist

0 Likes
SergeyN
Contributor III
Contributor III

I do not understand why reinvent the wheel?
Use ODAG

0 Likes
ajaykakkar93
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: