Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:)
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:)
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
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)