9 Replies Latest reply: Jan 29, 2013 9:13 AM by Henry Backman RSS

    Opening another qvw-file with specific sheet

      Hello everyone,


      I am working on this issue since two days so far and maybe someone out of the community shared the same issue so far.


      The problem so far:


      The goal was to integrate one application (B)  into another (A). But due to performance issues we suggested to some kind of fake integration by outsource one application (B) and open it by clicking on a sheet of application A. Application B shares the same sheet order than Application A and gives therefore the user the feeling to be within the same application but technically he is working with two, which gives us a great performance boost and the freedom of not having all dimensions in the current selection boss.


      The solution so far:


      Since QlikView unfortunately does not support the Sheet Action "Open QlikView Document" I had to use some kind of trick, by pressing via macro a button when entering the sheet, that performs the Action "Open QlikView Document", which works great on Client&Server.


      But it will always open on the last saved sheet/one specific sheet, which is fine if we come from application A to B, but the way back it should actually open the sheet I am clicking on. Application A has 7 sheets and if i click on "Country", it should open this sheet and not only one fixed sheet.




      I am looking for a solution to open another .qvw-file with a specific sheet.


      Thanks so far,


        • Re: Opening another qvw-file with specific sheet
          Gaurav Khare

          Hi David,

          Can you please elaborate your requirement... I would have use the binary statement for the purpose of integrating one qvw into another..

          Or if you want open a diiferent qvw then we can rather make use of button and on it's click event we can open another qv application.. Hope this gives you an idea




            • Re: Opening another qvw-file with specific sheet

              Hi Gaurav,


              thanks for your input.


              The requirement is to have two applications with the same sheet structure. Application A has 8 sheets, but on of this sheet (e.g. "Special") should be outsourced into another application due to its complexity and data input. Application B has therefore one one real sheet, but the other 7 sheets will be displayed to ensure consistency. If the users clicks in Application A on Sheet "Special", Application B should be opened and this sheet be activated. If I click however in Application B on any of the other sheets, Application A should be opened again and it should jump to the selected sheet.


              I was able to find a solution by myself.


              Beside the "Click a button"-Macro to evade the Sheet Actions Issue I am using the Transfer State functionality.


              I created an Inline Load with all possible sheets in both applications. If the user clicks on a specific sheet from Application B, he will also select the SheetID of this specific sheet. After that Application A will be opened, the Sheet ID passed and a macro started which will Activate the selected SheetID.


              Usally it would be easier to just use an OnOpenDocument-Trigger to jump to the correct sheet, but unfortunately the passing of the selection state happens after this action and the correct sheet wont be activated. A macro however happens to be after the passing of the selection states.


              Sorry if this problem sounds more complicated than it actually is, but QlikView gave me no choice.