6 Replies Latest reply: Mar 17, 2010 10:11 AM by selcuk45 RSS

    Link to Button?

      Hi;

      i have 2 qvw file(a.qvw and b.qvw) and i have a 5 button in a.qvw file and they connect to b.qvw file
      when i click button which is in a.qvw file i want to go to specfic sheet in b.qvw file
      and these 5 buttons which is in a.qvw file have to go b.qvw files each sheets...[:'(]

      ex:
      button1(a.qvw) link to sheeta(b.qvw)

      button2(a.qvw) link to sheetb(b.qvw)

      button3(a.qvw) link to sheetc(b.qvw)

      button4(a.qvw) link to sheetd(b.qvw)

      button5 (a.qvw) link to sheete(b.qvw)

      Thanks...

        • Link to Button?
          Vidyut Verma

          Hi,

          It is possible to get the behaviour specified by you using the modified URL for opening QVW file. You could call a QVW document with additional parameters (macro name) to execute a macro while opening the document.

          for example:

          qvp://<ServerName>/<Folder>/DocumentName.qvw?MACRO=MacroSheet1

           

           

          • Link to Button?
            MManders

            You can add two actions to the button. The first open the other QVW document and the second action activates the correct sheet in that QVW document.

            First action: External -> Open QlikView Document

            Second action: Layout -> Activate Sheet

            • Link to Button?

              use this macro in your " a.qvw "

               



              sub xyz()
              set app=activedocument.getapplication
              set newdoc=app.opendoc("...\b.qvw","","")
              newdoc.activatesheetbyid "sheet a"
              end sub
              call xyz()
              [\code]

              the above code will open the "sheet a " in b.qvw
              if you want to open another sheet in "b.qvw" from "a.qvw" , create another button and write the same code as above with a little variation.
              In the line // newdoc.activatesheetbyid "sheet b" //, use the "sheetname" which you want to open on clicking that particular button.
              ex: newdoc.activatesheetbyid "sheet c"

              thanks
              </body>
              • Link to Button?

                 

                use this macro in your " a.qvw "

                 



                sub xyz()
                set app=activedocument.getapplication
                set newdoc=app.opendoc("...\b.qvw","","")
                newdoc.activatesheetbyid "SH02"
                end sub
                call xyz()
                [\code]

                the above code will open the sheet with sheetid "SH 02" in b.qvw
                if you want to open another sheet in "b.qvw" from "a.qvw" , create another button in "a.qvw" and write the same code as above with a little variation.
                In the line // newdoc.activatesheetbyid "SH02" //, use the "sheetid" of the sheet which you want to open on clicking that particular button.
                ex: newdoc.activatesheetbyid "SH04"
                thanks
                </body>