article Document Chaining in Qlik Sense in Qlik Sense Documents

Document Chaining in Qlik Sense

ajaykakkar93 — Tue, 16 Oct 2018 08:53:40 GMT

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.

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).
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

We are going to use Sheet Navigation + Actions for Qlik Sense
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‌

Re: Document Chaining in Qlik Sense

juraj_misina — Tue, 16 Oct 2018 21:41:14 GMT

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

Re: Document Chaining in Qlik Sense

ajaykakkar93 — Thu, 18 Oct 2018 03:19:37 GMT

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.

Re: Document Chaining in Qlik Sense

juraj_misina — Thu, 18 Oct 2018 06:52:03 GMT

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

Re: Document Chaining in Qlik Sense

Dalton_Ruer — Mon, 10 Dec 2018 21:36:16 GMT

Love it. This works fantastically.

Re: Document Chaining in Qlik Sense

rh205bip — Wed, 12 Dec 2018 15:11:31 GMT

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?

Re: Document Chaining in Qlik Sense

rh205bip — Wed, 12 Dec 2018 15:18:18 GMT

*Update

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

Re: Document Chaining in Qlik Sense

psankepalli — Fri, 04 Jan 2019 03:38:18 GMT

Excellent article

Re: Document Chaining in Qlik Sense

ajaykakkar93 — Wed, 16 Jan 2019 03:59:27 GMT

Thank You.. for you appreciation people..

Re: Document Chaining in Qlik Sense

SergeyN — Mon, 06 May 2019 10:55:57 GMT

I do not understand why reinvent the wheel?
Use ODAG

Re: Document Chaining in Qlik Sense

ajaykakkar93 — Mon, 06 May 2019 11:16:24 GMT

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

Re: Document Chaining in Qlik Sense

124psu — Thu, 23 May 2019 18:27:03 GMT

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!

Re: Document Chaining in Qlik Sense

ajaykakkar93 — Fri, 24 May 2019 07:00:04 GMT

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

Re: Document Chaining in Qlik Sense

Wayne_101 — Thu, 05 Dec 2019 10:27:16 GMT

***************************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-99cc08eb3cb1'&
'/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-99cc08eb3cb1'&'/select/' & GetCurrentSelections('/select/','/',';')

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

PLEASE HELP

Re: Document Chaining in Qlik Sense

ajaykakkar93 — Thu, 05 Dec 2019 10:24:29 GMT

Did you try giving a value in url manually?

Re: Document Chaining in Qlik Sense

Wayne_101 — Thu, 05 Dec 2019 10:41:23 GMT

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-99cc08eb3cb1/state/analysis/select/COLUMN/['&Concat(Distinct COLUMN, '];[')&']',

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

Re: Document Chaining in Qlik Sense

ajaykakkar93 — Sat, 28 Dec 2019 05:42:46 GMT

GIF LINK:

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

Re: Document Chaining in Qlik Sense

Keshaw — Wed, 13 May 2020 06:43:44 GMT

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.

Re: Document Chaining in Qlik Sense

mountaindude — Wed, 03 Jun 2020 08:34:31 GMT

@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.

Re: Document Chaining in Qlik Sense

BjoernWollny — Mon, 08 Jun 2020 08:33:40 GMT

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!