topic Re: How to trigger same sheet in document chaining in QlikView

How to trigger same sheet in document chaining

punitpopli — Thu, 30 Apr 2015 10:11:58 GMT

Hi,

I am using QlikView's document chaining concept to activate another (app B) application from previous (app A) using Open QlikView Document as an action.

In my current scenario I have to open the sheet in App B on which I have clicked on App A.

For e.g.: If I clicked in sheet2 in app A the same sheet (i.e. sheet2) should get trigger in app B, below is the screen shot for sheet layout for your reference

To achieve above functionality I have used data island as sheet names along with existing sheet ID, below is the script for your ref.

SheetName:

LOAD * INLINE [

SheetName,SheetID

Sheet1, SH62

Sheet2,SH54

Sheet3,SH66

Sheet4,SH36

I have referred the blog https://community.qlik.com/thread/53743‌ and https://community.qlikview.com/thread/134654 but didn't find the solution of my issue.

Is there a way we can activate the same sheet on different application in Document chaining?

Thanks,

Punit

Re: How to trigger same sheet in document chaining

ankitaag — Thu, 30 Apr 2015 10:35:11 GMT

and where that sheet 2 in app B will get open?

you want when you click sheet 2, sheet 2 of App B should get open in that window?

Re: How to trigger same sheet in document chaining

ankitaag — Thu, 30 Apr 2015 10:39:38 GMT

Hello,

You can directly open another document in your current application.

Go to button properties - - Action - - Add - - External - - Open a Qlikview Document - - and write the application path which you want to open.

Re: How to trigger same sheet in document chaining

punitpopli — Thu, 30 Apr 2015 10:42:56 GMT

Hi AnkitaAg‌,

Thanks for your reply.

#1 : yes

#2 :I have used the same approach but I am not able to navigate to Sheet2 of App B in example above.

let me know if you need more inputs from my side.

thanks,

Punit

Re: How to trigger same sheet in document chaining

Anonymous — Thu, 30 Apr 2015 10:52:17 GMT

Hi,

Define a variable as follows in application1

vActiveSheet1 = SubField( GetActiveSheetId(),'\',2)

Also create a variable in second application as vActiveSheet2

When you use the Open Qlikview Document Action in first application, add one more action for Set variable.

Using this action, set the vActiveSheet2 = $(vActiveSheet1)

On each sheet of application 2 give a layout condition as $(vActiveSheet2) = 'give the sheet id here'.

Let me know if it works.

Regards,

Greeshma

Re: How to trigger same sheet in document chaining

punitpopli — Thu, 30 Apr 2015 11:04:22 GMT

Hi greeshma_k‌

Thanks for your reply

I have tried the same approach previously but variables value do not get passed when we move from one app to other.

Have tried your approach as well but didn't work.

Thanks,

Punit

Re: How to trigger same sheet in document chaining

Anonymous — Thu, 30 Apr 2015 12:04:49 GMT

Hi,

Sorry my bad. The variable values are not getting passed. I tried using the inline table table that you have created and was able to achieve this by using the Select in field button action. Please see attached QVWs.

Re: How to trigger same sheet in document chaining

PrashantSangle — Thu, 30 Apr 2015 12:23:00 GMT

Hi,

Hope you have created this table in both apps.

SheetName:

LOAD * INLINE [

SheetName,SheetID

Sheet1, SH62

Sheet2,SH54

Sheet3,SH66

Sheet4,SH36

];

Now just follow few steps;

1: On Button Click Trigger -> External->Open Qlikview Document -> Enter Document NAme with path

then must tick Transfer State and Apply state on top of Current.

2: And In AppB ->on each sheet->Property>General->Show Conditional

write if(SheetID='',1,0)

Regards

Re: How to trigger same sheet in document chaining

punitpopli — Thu, 30 Apr 2015 13:02:47 GMT

Hi greeshma_k‌

Thanks for your reply...It worked for me..

I was also trying the same way but in my App2 all the sheets was not conditionally hidden due to which it was not working as expected and when I hide them all conditionally (as in your example) it work fine based on either SheetID or SheetName..

Thanks a ton..

Regards,

Punit

Re: How to trigger same sheet in document chaining

Thu, 25 Jun 2015 21:07:52 GMT

i followed this approach. but not working for me. I'm accesing both the application through accesspoint.

Re: How to trigger same sheet in document chaining

mishraamit2485 — Fri, 25 Sep 2015 05:14:43 GMT

How did you do that.i'm not able to achieve the same, cn you guide me something.

Re: How to trigger same sheet in document chaining

ElizabethLamb — Fri, 09 Oct 2015 03:56:35 GMT

I realise this is an old post, but someone else may need this information too.

It should work if you check that the variables in the first app is checked to 'Include in Bookmarks' - then the variable values also get passed to the second app.

Re: How to trigger same sheet in document chaining

Anonymous — Tue, 29 Mar 2016 09:36:02 GMT

In my experience it works, but only with the IE Plug-in. If you are using Ajax (Full browser version) the triggers are not launched.

Re: How to trigger same sheet in document chaining

Anonymous — Tue, 29 Mar 2016 09:45:33 GMT

I'll explain my situation:

I need to navigate via Ajax (Full browser version) from one application to another one. Both hold the same data model and fields.

I need to transfer between them the current active sheet and all the selections made. I solved this with the OpenDocument+transfer state and the mentioned logical island for the sheet ID, but as with Ajax the 'On Open document' trigger doesn't work the opened document always navigates to the default sheet.

There is another option, using the open URL instead of open document, but as my documents have many fields and there can be more in the future, I would prefer a solution to transfer all the available fields selection instead of writing them one by one (as I've seen it's done with the open URL action).

Does anyone have a workaround for this?

Re: How to trigger same sheet in document chaining

Tue, 24 May 2016 11:41:35 GMT

Hi,

Is there any other way, where we can see all the sheets in App 2