Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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
124psu
Creator II
Creator II

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

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

0 Likes
Wayne_101
Contributor III
Contributor III

***************************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

0 Likes
ajaykakkar93
Specialist III
Specialist III

Did you try giving a value in url manually?

0 Likes
Wayne_101
Contributor III
Contributor III

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

0 Likes
ajaykakkar93
Specialist III
Specialist III
0 Likes
Keshaw
Partner - Contributor
Partner - Contributor

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.

0 Likes
mountaindude
Partner Ambassador
Partner Ambassador

@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
Contributor III
Contributor III

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!

0 Likes
BjoernWollny
Contributor III
Contributor III

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!

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