topic Re: Open other QVW and active a sheet in QlikView

Open other QVW and active a sheet

azimabadi — Thu, 12 Jul 2012 09:57:57 GMT

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

Re: Open other QVW and active a sheet

Fri, 13 Jul 2012 16:22:29 GMT

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

Re: Open other QVW and active a sheet

Fri, 13 Jul 2012 17:09:03 GMT

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

Re: Open other QVW and active a sheet

manideep78 — Tue, 28 Jul 2015 12:41:27 GMT

Hi PariPari‌ Azimabadi‌

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)