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‌

[124psu]

Is there a way to download this gif? The original author is showing a nice step by step and would like to be able to pause and follow through with his instructions! 

[ajaykakkar93]

Hi, Sorry i don't have a video of this i made a gif to upload.

[Wayne_101]

***************************DOCUMENT CHAINING QLIK SENSE*****************************

THIS IS WHAT I'M TRYING BUT BUTTON JUST TAKES ME TO APP2 BUT DOESN'T APPLY SELECTION FILTER FROM APP1 : 

='http://server.ip/sense/app/1006410b-eee0-4e3a-9079-80fb77cb9353/sheet/9d5f2a40-2086-45ea-a89d-99cc08...
'/select/' & GetCurrentSelections('/select/','/',';')

BELOW IS THE URL WHICH APPEARS AFTER CLICKING THE BUTTON FROM APP1 AND GOING TO APP2 :

='http://server.ip/sense/app/1006410b-eee0-4e3a-9079-80fb77cb9353/sheet/9d5f2a40-2086-45ea-a89d-99cc08...'/select/' & GetCurrentSelections('/select/','/',';')

COLUMN NAMES IN BOTH APPS ARE SAME EVEN CASE SENSITIVITY IS SAME

PLEASE HELP

[ajaykakkar93]

Did you try giving a value in url manually?

[Wayne_101]

nope i coped it from browser, chaining is done  by using below expression but it doesn't let me pass more then 10 selection . query times out.

='http://server.name/sense/app/fa7a997a-1fd2-4b67-9f47-e57d7627d194/sheet/9d5f2a40-2086-45ea-a89d-99cc... COLUMN, '];[')&']',

any solution for this ? i need to pass more than 10k selection from app1 to app2

[ajaykakkar93]

GIF LINK:

https://community.qlik.com/legacyfs/online/215994_Doc_chan.gif

[Keshaw]

Hi @ajaykakkar93  and fellow mates,

I have been trying to pass the filter selections from one app to another and as suggested by ajay , tried that way. But, maximum 6 is being reflected . But, after few workarounds was able to pass maximum 12. selections from a single filter pane . However, I want to pass upto 80 selections.

Please help if this can be resolved.

[mountaindude]

@SergeyN 

I agree - ODAG addresses a very similar use case. I however often find end users struggling with ODAG, that little button in the lower left corner might be fine, but then you get a meny with already created apps etc - it's way more complicated than it should (for the use case discussed here). 

A simpler solution can certainly be useful. 

[BjoernWollny]

Hi,

this solution is great - thanks for sharing. But I have a quite nasty issue. I have several often used fields with values containing a slash /

eg Date 06/03/2020 or for plants we are using plant code plus some letters for better readability eg 1110/ATT

Is there any way to still handover such field values by URL? I tried "" or '' but it didn't work. Or at least any possibility to handover keys of selected data (eg. for Date I have a field Key_Date that represents date but as number)

Really appreciate any help!

[BjoernWollny]

I continued to search for solutions and found another version of the formula, which is more robust to the field values:

GetCurrentSelections(']/select/','/[','];[',50) & ']'

So everything works just perfect 🙂
Maybe you can add this to the initial post in order to directly help others.

best regards!