1 Reply Latest reply: Feb 24, 2014 4:48 PM by Oleg Troyansky RSS

    Combining multiple sheets from multiple workbooks using different data sources into one

      I have two teams that have been working separately to develop different qlikview workbooks. I now need to combine these so I've been looking for the most elegant way to combine two workbooks which use different data sources. I've seen this approach: http://community.qlik.com/message/363474 however, this applies to two workbooks pulling from the same data source.

       

      My plan right now to combine workbook 1 with 2 is to copy everything from 2 into 1 by:

      1. Copying the script
      2. Copying all variables
      3. Copying all sheet objects into new sheets

       

      I'd like to know if a) there is a more elegant way to conduct this process and 2) if this process would serve as a complete import of the second workbook. Thanks in advance.

        • Re: Combining multiple sheets from multiple workbooks using different data sources into one
          Oleg Troyansky

          Hmm, I'm afraid it's not always as simple as that... here are some pointers to think about:

           

          1. Copying the script - be careful when combining the two data models. You really need to ensure that the two sets of entities play well together and don't create any problems with multiplicity, loops etc... This is perhaps one of the most important reasons for not being able to offer such as merge "out of the  box".

           

          2. Copying all the variables - yes, true. In addition to variables, additional entities may need to be checked:

           

          - Groups

          - Actions and Triggers

          - Macros

          - Alternate States

          - Custom Number formatting settings

           

          3. Copying the sheet objects:

           

          This is perhaps the most trivial part - Ctrl-A, Ctrl-C to copy, Ctrl-V to paste in the new document. Keep in mind that you may have some conditionally hidden objects. If you use conditional show/hide, all the conditions need to be turned on one by one and the corresponding objects copied individually. Alternatively, you can press Ctrl-Shift-S to toggle "show all" setting. This way, you can copy all the objects at once.

           

          good luck!

           

          Oleg Troyansky

          www.masterssummit.com