3 Replies Latest reply: Jul 28, 2015 8:41 AM by Manideep Hv RSS

    Open other QVW and active a sheet

    Peyman Azimabadi

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

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

              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

            • Re: Open other QVW and active a sheet
              Manideep Hv

              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)