How to trigger same sheet in document chaining

[punitpopli]

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

[ankitaag]

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?

[ankitaag]

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.

[punitpopli]

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

[Anonymous]

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

[punitpopli]

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

[Anonymous · Accepted solution]

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.

[PrashantSangle]

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

[punitpopli]

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

[#10]

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