topic Re: Document Chaining Sheet Navigation issue in QlikView

Document Chaining Sheet Navigation issue

Mon, 27 Jul 2015 09:13:49 GMT

Hi Team,

We have two applications in our project and we are implementing document chaining to integrate two applications.

While implementing the Document chaining one requirement came up that is if we are in sheet A while navigating from app1 to app2,

same sheet should be opened on app2.

Here i am attaching a sample applications test.qvw,test2.qvw.

i have three sheets A,B,C in both applications.

if i am in sheet A of test App, navigating to Test2 App----Test2 should be opened in Sheet A

if i am in Sheet B of test App,navigating to Test2 App-----Test2 should be opened in sheet B.

Same from Test2 to Test App for all sheets.

Thanks in advance,

Nani

Re: Document Chaining Sheet Navigation issue

vardhancse — Mon, 27 Jul 2015 09:27:45 GMT

Hi,

In button(On click opening Test2 APP)

Enable Transfer state.

And

Apply some triggers in both the applications

Re: Document Chaining Sheet Navigation issue

Mon, 27 Jul 2015 09:32:05 GMT

Hi Sasi,

Transfer state was enabled and i am able to transfer the selection and my requirement is like to navigate to the same sheet in the second application.

Thanks,

Nani

Re: Document Chaining Sheet Navigation issue

datanibbler — Mon, 27 Jul 2015 09:37:34 GMT

Hi Nani,

you need a macro to do that.

I was facing the same issue some time ago and our external consultant wrote us a macro, a very simple one. I paste the code here, it's no secret - and it's really easy.

The trick is, you need an Inline_table - exactly the same in all applications involved in the chaining_scheme.

Then you transfer that selection and you have to set up/ adapt the macro to identify that selection and open the corresponding worksheet - there are just two options in the macro right now, but I guess you can make that just as many as you want, you just have to use an "elseif".

_______________________________________________-

sub Arbeitsblatt_Selektion

set sel = ActiveDocument.fields("__KPI").GetSelectedValues

if sel.count = 0 then exit sub

Diagramm = sel.Item(0).text

if Diagramm = "Fluktuation" then

Diagramm = "SH19"

else

Diagramm = "SH02"

end if

ActiveDocument.Sheets(Diagramm).Activate

end sub

HTH