Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

azimabadi
Contributor II

Open other QVW and active a sheet

Hi all,

i have two QVW files: QV1 and QV2. QV2 has 2 tabs.

i need to place two buttons in QV1.

when Button 1 clicked i want to open QV2 and activate Tab1.

but when Button 2 clicked i have to open QV2  and activate Tab2.

my problem is to activate a tab in QV2.

i tested a disconnected field with Tab Names or Codes and make a selection on this field,

then passing the state with "transfer state" option of "open qlikview document" action , and a trigger on this field in QV2.

when i click buttons, selection is made and transfers to QV2, but trigger dosn't run.

Best regards

Peyman

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Open other QVW and active a sheet

try this

file 1

make a variable

button 1 - variable =1

button 2 - variable =2

macro

- on button 1 and 2 - save the variable to file

file 2

make a variable

on open run macro - load variable from file

on open activate sheet (using variable)

i've got no time today to check it but if you won't get it till tomorrow i'll figure it outSmiley Happy

3 Replies
Not applicable

Re: Open other QVW and active a sheet

try this

file 1

make a variable

button 1 - variable =1

button 2 - variable =2

macro

- on button 1 and 2 - save the variable to file

file 2

make a variable

on open run macro - load variable from file

on open activate sheet (using variable)

i've got no time today to check it but if you won't get it till tomorrow i'll figure it outSmiley Happy

Not applicable

Re: Open other QVW and active a sheet

This may help you (or not).  We have an excel file that has a hyperlink that opens the IE Plugin, opens a particular document and opens to a specific sheet based on a variable.  Heres how we implemented it.

1) In the QV document we created a variable vOpeningSheet

2) In the Document Event Trigger we call a Macro to run OnOpen. The Code is

sub GoToSheet

set v = ActiveDocument.Variables ("vOpeningSheet")

if v.GetContent.String = "1" then

"SH44").Activate

"0", True

else

if v.GetContent.String = "2" then

"SH49").Activate

"0", True

else

"0", True

end if

end if

end sub

3) The hyperlink code is:

http://QVServer/qvplugin/opendoc.htm?document=YourDocument.qvw?vOpeningSheet=2

This opens the plugin, opens YourDocument.qvw and send a value to the variable vOpeningSheet. The OnOpen is then triggered with the variable to open the document to the sheet set up in the Macro above.

Hope This Helps,

Stephen

manideep78
Valued Contributor

Re: Open other QVW and active a sheet

Hi PariPariAzimabadi

Can you please explain the below functionality. I got the same requirement as below.

file 1

make a variable

button 1 - variable =1

button 2 - variable =2

macro

- on button 1 and 2 - save the variable to file

file 2

make a variable

on open run macro - load variable from file

on open activate sheet (using variable)

Community Browser