Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

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
Sarvajit
Contributor II
Contributor II

I love the way you explained it. It is working perfectly , but  I have a doubt.

Url vary from one environment  to other (like Dev, UAT and prod). How can we manage it?

 

0 Likes
Dalton_Ruer
Support
Support

You will need to adjust based on the application GUID in each environment. Typically solved via a variable so that the variable is set for each environment and the button evaluates the variable.

0 Likes
xx75
Contributor
Contributor

Dear all,

I used the suggested solution using "GetCurrentSelections" and it works properly, but not with the field I'm interested in.  I suppose the problem is related to the composition of the field ex "A/1111111/111/11".

I don't think that Qlik appreciates "/". Do you have any suggestion?

Thank you

I FOUND THE SOLUTION IN THE PREVIOUS PAGES... THANK YOU

 

0 Likes
wlau
Contributor III
Contributor III

Hi,

I keep getting the message "ACCESS DENIED" trying to open the second app.  if I go through the Hub and  open the same app , I don't get that message.

Any suggestion?

0 Likes
naamah
Contributor III
Contributor III

Hi!

it works just great!!!

but i need your help to implement another action before navigation.

I want to select all possible values in one field -> then clear all other selections in other fields -> and only then to navigate to the other app.

I tried the 2 actions accordingly but it seems that the navigation occures before the actions?

when i press the button i can see in the generated URL that it passes the values in field X which i requested to clear in  action 2. however, when i go back to the source app i can see that both actions were applied. 

can you suggest?

Thanks!!!

 

0 Likes
airflight90
Contributor II
Contributor II

I have tried with a date field e.g. '07/01/2023 12:00:00 AM') and that did not work. 

Here is the last part of the URL:

/select/DateDTS/9/1/2021%2012:00:00%20AM 

Any helps will be appreciated. Thanks

ajaykakkar93
Specialist III
Specialist III

let me give it a try

BjoernWollny
Contributor III
Contributor III

@airflight90 it will not work due to the "/" inside of your date. Just use square-brackets [] 

 

eg:

/select/DateDTS/[9/1/2021%2012:00:00%20AM]

 

So in case you have various selections you can use:

=if(GetSelectedCount(DateDTS)>0 ,'select/DateDTS/['&concat(DISTINCT DateDTS,'];[')&']/',  '')
 
Hope this helps
Version history
Last update:
‎2018-10-16 04:53 AM
Updated by: