Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
azimabadi
Creator III
Creator III

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

1 Solution

Accepted Solutions
Not applicable

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 out:)

View solution in original post

3 Replies
Not applicable

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 out:)

Not applicable

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
Partner - Specialist
Partner - Specialist

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)