topic Re: document chaining qlik sense in App Development

document chaining qlik sense

124psu — Sat, 16 Nov 2024 20:48:20 GMT

Hi All -

I created a similar post to "New to Qlik Sense" but no luck there. I was hoping my question is suitable to place in this thread.

I have 2 separate apps (although similar data with common field names) and would like to pass filter pane values from one app to another. I followed this guideline from Ajay (https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Document-Chaining-in-Qlik-Sense/tac-p/1576855).

I have it all set up exactly how he instructs in his thread but once I click my newly set up button to send values through the filter pane to another app, I get a Qlik Sense error (The resource could not be found). I also noticed the URL I grab from the dev hub shoots me to an actual web page. I also noticed when I play with my URL it actually does send me to the sheet of the app I wanted, but I see no values passed over. On top, the pivot table is static and will not scroll up or down.

Are there any extensions that stays within Qlik Sense? Hoping someone can route me to the right direction with my problem.

Much appreciated.

Re: document chaining qlik sense

lironbaram — Thu, 23 May 2019 20:21:56 GMT

you can use this expression it'll do the trick

='https://sense.qlikil.net/sense/app/b51c8aee-b7cd-424e-af63-be1b60888342/sheet/PfKsJK/state/analysis/select/'&
GetCurrentSelections(']/select/','/[','];[',50) & ']'

of course you need to replace with your server name and app and sheet id

Re: document chaining qlik sense

124psu — Thu, 23 May 2019 20:44:23 GMT

Hi, just to clear up some ambiguity on my end, this is my URL that is receiving the passed values from another app. I got this URL by going into the DEV HUB and into 'single configurator' and selecting my app and the sheet I want to pass values over.

http://localhost:4848/single/?appid=C%3A%5CUsers%5Candrew%5COneDrive%20-%20CACA%5CDocuments%5CQlik%5CSense%5CApps%5Cefc%20transaction.qvf&sheet=395685aa-7027-4f88-a9d3-7f7c67cc40a6&opt=nointeraction&select=clearall

So I took this URL, following the instructions and have an updated syntax of:

'http://localhost:4848/single/?appid=C%3A%5CUsers%5Candrew.so%5COneDrive%20-%20CACI%5CDocuments%5CQlik%5CSense%5CApps%5Cefc%20transaction.qvf&sheet=395685aa-7027-4f88-a9d3-7f7c67cc40a6' & '/select/'& GetCurrentSelections('/select/','/',';')

I am beginning to think my issue is arising from the URL piece. As in your URL, I see /state/analysis/... I actually do not have that embedded in the given URL from the DEV HUB. I manually added that piece as well and still no luck with properly passing values over. Let me know if you have any additional thoughts on this. Much appreciated for the feedback!

Re: document chaining qlik sense

lironbaram — Fri, 24 May 2019 05:34:04 GMT

why to you want to use this url and not the straight forward url in my example

if you want to jump from one app to the other my url is the right one to use ,

your url is used to put qlik object inside iframes

Re: document chaining qlik sense

ajaykakkar93 — Mon, 27 May 2019 04:25:24 GMT

Clear me this,
Do you want to show object from Single configurator?

Re: document chaining qlik sense

ajaykakkar93 — Mon, 27 May 2019 04:26:34 GMT

Hi,

You can use this Solution also.

Re: document chaining qlik sense

ajaykakkar93 — Mon, 27 May 2019 04:29:44 GMT

Do you selected content has special char?

Re: document chaining qlik sense

124psu — Wed, 29 May 2019 19:53:44 GMT

Hi Lironbaram,

So I have updated my url to match what you have mentioned. I am still getting an error.

new syntax:

'http://localhost:4848/single/?appid=C%3A%5CUsers%5Candrew.so%5COneDrive%20-%20CACI%5CDocuments%5CQlik%5CSense%5CApps%5Cefc%20transaction.qvf&sheet=395685aa-7027-4f88-a9d3-7f7c67cc40a6'& '/state/analysis/' & GetCurrentSelections(']/select/','/[','];[',50) & ']'

I added the '/state/analysis/' portion since my url did not include those strings. It seems like it should have been there but there is not. When I use this syntax all looks good if I bring in a separate text box just to make sure my values are being picked up. Also, my destination URL is within my qlik sense desktop, hence the 'localhost:4848', but it still routes me to the web browser and I am left with the same error message of 'no resources found'

Re: document chaining qlik sense

124psu — Wed, 29 May 2019 20:12:27 GMT

Hi Ajay,

I would like to pass values from many filter panes from App #1 to App #2. So If I have fields that have State, City, Country, Year, etc. the users will select those values, and once they press the button, it will send them over to App #2 with those same values intact. I followed your instructions on your thread but am still running into trouble.

-------- Updated --------

So I have updated my url to match what you have mentioned. I am still getting an error.

new syntax:

'http://localhost:4848/single/?appid=C%3A%5CUsers%5Candrew.so%5COneDrive%20-%20CACI%5CDocuments%5CQlik%5CSense%5CApps%5Cefc%20transaction.qvf&sheet=395685aa-7027-4f88-a9d3-7f7c67cc40a6'& '/state/analysis/' & GetCurrentSelections(']/select/','/[','];[',50) & ']'

Re: document chaining qlik sense

124psu — Thu, 30 May 2019 16:17:23 GMT

Hi Ajay,

I was finally able to get my button to push users to a new app. I got the correct URL by going into the browser hub. My URL looks something like this.

'http://localhost:4848/sense/app/C%3A%5CUsers%5Candrew.so%5COneDrive%20-%20CACI%5CDocuments%5CQlik%5CSense%5CApps%5Cefc%20transaction.qvf/sheet/395685aa-7027-4f88-a9d3-7f7c67cc40a6/state/analysis'
&
'/select/' & GetCurrentSelections('/select/','/',';')

Now my new issue is that none of the filter pane values (selections) are being pushed to the new app. It doesn't take into account the pre selected values in the filter pane. You can see in my URL that I have the '/select.... GetCurrentSelections.etc' syntax. Any ideas where I am going wrong on this? Thanks

Re: document chaining qlik sense

124psu — Thu, 30 May 2019 16:21:31 GMT

quick update - I am testing 3 filter panes and it seems that one of the filter panes is working very well. I have 2 other filter panes that are not working. After testing the non-working filter panes individually it doesnt seem to take it into account for some reason.. I have filter panes - Year, State, Account

State filter pane is passing the value but my Year and Account filter pane is not working at all.. a bit lost on how that can happen especially if one of the filter panes are working fine.

Re: document chaining qlik sense

124psu — Thu, 30 May 2019 17:06:09 GMT

All, I have now got the document chaining to work exactly how I expected. Big shout out to Ajay and Lironbaram for helping me out with this. Just a quick pointers and what I've learned to help out others who will be needing to implement this moving forward..

- Document chaining is very useful to avoid bringing in tons of data and instead keeping your model simple by creating multiple apps and switching back and forth by having pre-selected filter pane values pass those values to the next app.

- When using the URL, make sure to grab the URL from the web browser version

- I've done many readings on document chaining up to this point and realized many other users had their web browser url include the '/state/analysis' piece whereas I did not have that. I simply added that string onto my URL by using an '&'

- This one is key - your filter pane values will not pass if the column/field name is not the same. I did a quick test just to make sure and I believe that is how it behaves. E.g. if you have a column name [Calendar Year] in one app and [CY] in another app, the document chaining will not work. You must either rename the field name in either APP1 or APP2 so that it matches. There will be some clean up needed but wanted to point this one out as well.

- My app currently is pushing filter pane values to a granular table to a second app with many filters. I'm not sure what the limit is but so far, for my needs, the limit doesn't seem to be a problem going against the syntax - GetCurrentSelections(']/select/','/[','];[',50) & ']'

Thank you all for chiming in and helping me stimulate my brain to figure this problem out. I wish Qlik would have something similar out of the box in its next version but this will do for now!

Re: document chaining qlik sense

Keshaw — Wed, 13 May 2020 05:54:36 GMT

I have been trying to implement the same functionality to pass more than 50 selections from one app to another by the steps mentioned by you and by Ajay and Lironbaram but to no avail.

I want to pass multiple filters with various selections but the navigation occurs only for limited number of selections...Beyond that it says the URL is not found. I am using qliksense enterprise edition.

Please let me know if this can be helped.

Re: document chaining qlik sense

Skashid — Tue, 15 Mar 2022 20:23:01 GMT

Hi @ajaykakkar93 ,

Firstly thanks a lot for sharing the document chaining steps they helped a lot.

I too have similar requirement which @Keshaw has stated where need to pass multiple filters.

but after executing the steps i get an error which says "Request URL TOO Long"

can you please help on this one like how we can overcome the limited number of selections

Re: document chaining qlik sense

markperrone — Fri, 12 Apr 2024 12:31:47 GMT

The URL method is not reliable. Sometimes it works and other times it doesn't. The only solution is to have Qlik change enterprise to match what Cloud does.