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‌

[Sarvajit]

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?

[Dalton_Ruer]

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.

[xx75]

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

[wlau]

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?

[naamah]

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

[airflight90]

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]

let me give it a try

[BjoernWollny]

@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

[markperrone]

We tried this but found it was unreliable. Sometimes the detail app would open and other times it was just a blank screen.  other times it would time out.  when it works its fantastic.  There is also the varied limitation of the URL length.  Firefox supposedly has a 65,000 character limit.  not sure if the errors are because of the browser or qlik sense.

what we really need is the ability for the Qlik/API to effectively pass a bookmark to a chained app but from comments on the community I'm not sure if anyone has built a successful solution.

[Radoslaw]

 Ajaykakkar93 Is there a way to make this filters that are passed in URL to be in state "LOCKED" ?